I am opening an excel document in Excel 2000. This document was sent to me by someone outside the company. It has links to a file on this guys PC. When I open it in Excel 2000 I can see the correct data until I click on the box to not update links, I don't want to do this because it will not see the links. As soon as as I click the button it recalculates the workbook and shows everything as #NAME?. I know that this because Excel is recalculating all the formulas because the document was created in an earlier version, Excel tells me this. But what it does not tell me is how to get round it. Is there away?
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 document in Excel 2000. Recalculates formulas on open!
- Thread starter nordberg
- Start date
Open Excel 2000 and open a blank workbook. Goto Tools/Options and click on the Calculations Tab. Under Calculation click Manual but untick recalculate before save. Ok these chanages. Now leave this blank workbook open and also open the Excel 97 document with the problem and click don't update. You will find this has worked. If you save this file now you will not have to do this again.
- Status