To stop this you need to make a registry entry (Start->Run "Regedit" (no
quotes)).
Under:
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
create a new DWORD item named: FullCalcOnLoadOldFile
Leave its value at the default of 0.
Note that even after this change if the workbook was not fully calced, and
you calc it, you'll get the usual "save changes" prompt.
--
Jim Rech
Excel MVP
"gmw" <geo...@northampton1.com> wrote in message
news:1BF3AB7E-0D94-457F...@microsoft.com...
|I upgraded to Office 2000. Now whenever I open an excel file from someone,
it says "Microsoft Excel recalculates formulas when opening files last saved
by an earlier version of Excel". Can I make this automatically save so I do
not have to click yes or no each time? I have clicked around but have not
found anything. Can you tell me how to change this?