Software

Ask something
Discussion Locked

Question on an Excel file

0 helpful
5 replies

by hunterzh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

5 replies

by fungus-among-us

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

by hunterzh

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

by cliff

Had a customer encountering same problem like mentioned...

wonder if anyone has any luck resolving this?

by su.burrows

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!

by sup.banerjee

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.

This discussion is closed to new replies.