General discussion

Locked

Question on an Excel file

By Hunterzh ·
I have an Excel file from others. When trying to open it in Excel 2003, it prompts that "This workbook contains links to other data sources. If you update the links, Excel attempts to retrieve the latest data; if you don?t update, Excel uses the previous information". But no matter you update or not, many cells appear as "#NAME?". While when I open it in Excel XP, those cells will have numbers inside. Actually in those cells, they are some formulas. Is it a problem of Excel 2003?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by fungus-among-us In reply to Question on an Excel file

Yes, it's a problem with Excel 2003. Sounds like you don't have the same add-ins (plug-in) loaded on 2003 as you do for XP. Check your add-in setting is OXP and compare them with O2003 (Tools, Add-Ins...)
Let us know if this was the problem or not....

Good Luck

Collapse -

by Hunterzh In reply to

I've tried, it doesn't work. Also I try to install all functions of Office 2003, it doesn't work either.

Collapse -

Customer encounterd same problem....

by cliff In reply to

Had a customer encountering same problem like mentioned...

wonder if anyone has any luck resolving this?

Collapse -

by su.burrows In reply to Question on an Excel file

http://support.microsoft.com/kb/327006/en-us?spid=2512&sid=97

This is "by design" as workbook created in an earlier version and whether you say update or not it forces a "recalculation" of entire workbook and so seeks verification from external sources...

See the KB article for more info - either you downgrade to read it, or they upgrade and re-do links... or you get rid of links altogether, or get access to link to the links they created!

Most unhelpful me thinks of Microsoft, although it says it's "by design" and so therefore not a bug!

Most painful when doing budgets!

Collapse -

ez

by sup.banerjee In reply to Question on an Excel file

This is a problem since who ever prepared the file copy pasted values in particular formulas from another open workbook. Go to edit links and you will see the links and the name of the other workbook. You can do 2 things..one is break the link using an option there or get the source workbook to which this excel file has a link from this menu and save it in the required location. I am sure this would solve your problem.

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums