Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Add-ins problem when I copy my excel file to another PC

Hi There:

I downloaded some functions from the Internet, and created a tool that I use for my job. To use those functions I just added them as add-ins.

Now I want to share that tool with a co-worker, so I sent him the functions I downloaded and my .xls file.

When he opened the .xls file, he added the funtions also as add-ins but the weird thing is that everytime that he opens the .xls file, he has to de-select the downloaded functions from the add-in and select them again.

I noticed that everytime he opens the Excel file, the system tells him that the file "contains automatic links to information in another workbooks" and the thing is that he only has a copy of my file and my file is a simple file with the add-in and he has the add-in functions in his computer.

What am I doing wrong?

David


Post your answer or comment

comments powered by Disqus
Dear Sir,

my excel file is corrupted i think due to virus. when i open my excel file
that not show in english language but shown in other language like @,$ etc..
if any solution to get back my important excel file ..please do tell me about
that.
i will waiting for your answer.

Dear Sir,

my excel file is corrupted i think due to virus. when i open my excel file
that not show in english language but shown in other language like @,$ etc..
if any solution to get back my important excel file ..please do tell me about
that.
i will waiting for your answer.

When I Copy an excell file to a CSV file format and than copy the CSV file to
a Notepad to be imported into a software program, the CSV file show no date
or characters in certain cells, however when I view the note file there are
commas in cells that were not showing in the CSV file. Hence, I have to
remove these commas in the Notepad file before I can inport the file. I need
to know how to copy an excel file to a CSV file without copy background or
unseen format characters.

I want to hyperlink pdf files to my excel file, however, I would like to
embed the pdf files within Excel so when I send my excel file to another user
with no access to my pdf files, I wouldn't need to attach all the associated
pdf files.

Hi, I made a customized menu bar and I have the problem that when I copy my
Excel file to another computer and I press a button of my menu bar, The
button doesn’t find the macro, so I need to define again which macro
correspond to which button, Âżhow to save the root directory with the macro so
whatever computer is my Excel worksheet run, the macro is assigned to the
customized button on the menu bar.

TIA

Problem when I opening a Excel (Office XP) file into Excel (Office 2007) in relates to Chart

I have migrated the office XP into Office 2007. I have created a worksheet with lot of Simple charts in Excel XP. When I opening the file in excel 2007 the chart is disturbing. Eg: one 'X' Axis and Two 'Y' Axis data with simple line chart in Excel XP.  When I opening this file in excel 2007 the graph is not coming to the end of the line. Can I get solution for this.

#ref in a linked cell (with formula in it), when i copy/cut and past in original cell

i have an order entry sheet that feeds a invoice sheet...

the invoice sheet has formulas that refer to the order entry sheets data (e.g., quantity)

when i move data around (cut/copy and paste) as i change/modify the order, my formulas in the invoice sheet turn to #ref...

?what can i do to stop the #ref...?

thank you.

When I copy an Excel file, the headers and footers are missing in the copy.
Is this a bug? Whats the fix?

I have a file that contains many macros ( 20-30). I use it all the time
and tried saving it in my Personal file (file that comes up
automatically when starting Excel2000-XLStart), as an add-in, as a
hidden file. No matter what I do this file slows down my navigation
when I have other Excel files open. I do a lot of Control-Tab to go
from file to file and having this file open slows Excel down. I like
having this file open because of all the useful macros. Any suggestions
on how to speed Excel up? Any ideas why this might be slowing Excel
down?

Thanks

How can i allow my excel webpage to be edited and not read only, so i can
edit & save it on the net? Ive uploaded the page and want to edit it through
excel and reupload it via excell, but my page when i open it through excell
says its readable only.

When I copy a spreadsheet to another workbook, the data values all change by
4 years backward.

Hi all,

can anyone please help me with this problem :

I have a lot of workbooks with the same lay-out that contain data for different regions. One sheet in every workbook contains a number of charts.
I have edited and added to these charts in one workbook, and now want to copy the result to all other workbooks.

Here's the problem : when I copy the charts-sheet to another workbook, the data-series still refer to the original workbook. Using ctrl H replace [oldworkbookname] with "" (nothing) doesn't work on the charts.
How can I remove the links to old workbook in one go, and not remove them one by one ?

Thanks,

Wouter

Hi. Is there any way for my excel file to save to a folder on another computer within the same network?

I'm trying to get it to save to path:

1031mbo3cDocuments and SettingsManagerDesktopBOWSER

which is the folder where the file resides on the other computer

however it doesnt seem to be saving :/

Thanks!

Hello,

I recently upgraded from Excel 2002 to Excel 2003 and discovered that some of my macros lost their shortcut key. It's not ALL the macros, just some of them - no apparent rhyme or reason.

I fixed my macros... however I now have another problem. When I send my excel file to other users, the macros won't work for the users that still have Excel 2002 because the shortcut keys are gone again for their version.

I can't have all the users reassign the letter each time they use my files.
Is there any settings or something that needs to change in my file?

Thanks, Mary-Lou

HI, I have a question for you.
Usually I need to copy a pivottable from a excel file to another (Excel
2003), to do this I click on source file A.xls and an excel application
startup, after I click on destination file B.xls and this start another
excel application too.
I select and copy the pivottable from file A and after paste the pivottable
on file B, but only values and formats are copied not the data, if I do
right-click of the mouse button on pivottable copied on file B there isn't a
menu for pivottable.
This work only if I open file A and B from the same excel application, but
normally I open the xls files from explorer and this open more that one
excel.
I remember that with excel 2000 I do this, but I not remember if excel 2000
opened the a both files on the same application or not.
Is possible to bypass this trouble because many job colleagues copy
pivottable in this way whitout to verify if the pivot is correct and loosing
the pivottable data.

Thanks in advance
Simon.

When I open an Excel file attached to an email, it opens as a read-only file.
How can I chage this to open as a regular excel file?

EXCEL: When I EXPORT an xls file to csv or other delimiter file , by how many ways I can do it ? how i configure EXCEL to export as
FIELDS SEPARATED BY ',' -or- FIELDS SEPARATED BY ';'
FIELDS ENCLOSED BY '"' -or- FIELDS ENCLOSED BY '''
LINES TERMINATED BY 'n'

When I save as xxx.csv I have any choice over:

FIELDS SEPARATED BY ',' -or- FIELDS SEPARATED BY ';'
FIELDS ENCLOSED BY '"' -or- FIELDS ENCLOSED BY '''
LINES TERMINATED BY 'n'

???

Sometimes when I open an Excel file, the colors are changed. I suspect it has
something to do with having another Excel file open that was exported from a
web page, but I don't know. Has anyone else heard of this?

How do I move a sheet from 1 Excel file to another? I tried the "move or
copy sheet" function, but in the "To Book" dropdown list, the only things
listed are the current book or a "new book" -- the one I want to move it to
is not listed.

Does anyone as an idea how can I protected a excel file to specific computer, so that it can’t be opened or used in any other PC??

This without using any other excel file.

Thanks

How do I move a sheet from 1 Excel file to another? I tried the "move or
copy sheet" function, but in the "To Book" dropdown list, the only things
listed are the current book or a "new book" -- the one I want to move it to
is not listed.

Hi!

I would like to copy several sheets from one Excel file to another excel file. Is there any easy way to do that instead of copying one at a time. Is it also possible the sheet name is automatically copied?

Please advise,

Aijun.

When I move my Excel macro to another PC, once I compile it on that PC it
works - until I logoff. Next time I logon it doesn't work again until I
recompile the macro. How do I save it permanently?

Raybs

Every time I save an excel file to a compact disc it saves as read only. I
can't seem to change this setting. I am new to office xp and this is really
frustrating me. Help!


No luck finding an answer? You could always try Google.