I have a spreadsheet created from Excel 97 containing various links. Some of those linked spreadsheets have been deleted. However, when openend in 97 it still keeps the previous values. But when I open in Excel XP, those linked cells (where the spreadsheets no longer exist) displays as #NAME. I checked the Microsoft site and they mentioned that this could be related to missing Add-Ins. I tried adding and removing all and some Add-Ins. But still the same result. Anyone have any solutions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel 97 Spreadsheet opened in Excel XP for cells of #NAME
- Thread starter canary
- Start date
- Thread starter
- #3
The #NAME is coming from other cells that are referring to links that the sheets have been deleted. The formula is just +K27+K28 etc., nothing fancy. If I open the sheet in 97 it remembers the last values known to the linked sheets before they were deleted. But when opened in XP it does not remember them and displays #NAME thus affects formulas etc..
- Thread starter
- #5
Already is set to "Save external.....". It's just so weird that when you open on 97 you can see the values. Then in XP they turn to #NAME. Strange!!!! I have rechecked it the main source cell that has a link i.e. ='L:\Buc\IBD\REGION\1998\NOV98\[WWRE2.XLS]FRONT'!$H$21+'ISG Adj'!M32 says #NAME, then subsequently those cells referencing to that turn to #NAME.
Canary,
From what you have posted so far dont know if this will help any. But I have found that when people are upgrading from one version to another and they have a workbook that is displaying #NAME it is ussually because they have a cell with a function that uses the analysis toolpak. So try going to Tools/Addins and checking the Analysis Toolpak. Like I said dont know if it will help but definetly wont hurt.
Good Luck,
Wray
From what you have posted so far dont know if this will help any. But I have found that when people are upgrading from one version to another and they have a workbook that is displaying #NAME it is ussually because they have a cell with a function that uses the analysis toolpak. So try going to Tools/Addins and checking the Analysis Toolpak. Like I said dont know if it will help but definetly wont hurt.
Good Luck,
Wray
- Thread starter
- #7
Wray,
Tried the add-in, still did not work. The funny thing is that when I initially open the workbook and can see the numbers in the cells. Then when it asks me if I would like to update the links, I press no (saying that it will keep the displayed numbers) the cells turn to #NAME.
Tried the add-in, still did not work. The funny thing is that when I initially open the workbook and can see the numbers in the cells. Then when it asks me if I would like to update the links, I press no (saying that it will keep the displayed numbers) the cells turn to #NAME.
Canary,
Try to set calculation to manual and open the spreadsheet. At least you can have access to values.
Do you have any message concerning macros? High security, unlike previous versions, is the default option in office XP, so user defined functions will be automatically disabled (should be changed to medium to have control on macros).
Possibly you try to open the file on two machines, follow Wray's suggestion and check what are ALL installed add-ins on the computer where you have no error message and compare with installed in XP machine.
What is in your workbook in 'ISG Adj'!M32? If #NAME, then this error is not produced by external link.
combo
Try to set calculation to manual and open the spreadsheet. At least you can have access to values.
Do you have any message concerning macros? High security, unlike previous versions, is the default option in office XP, so user defined functions will be automatically disabled (should be changed to medium to have control on macros).
Possibly you try to open the file on two machines, follow Wray's suggestion and check what are ALL installed add-ins on the computer where you have no error message and compare with installed in XP machine.
What is in your workbook in 'ISG Adj'!M32? If #NAME, then this error is not produced by external link.
combo
- Status