Excel recalculates formulas when opening files last saved by an earlier version of Excel

[Jim Rech]

You get this particular message only when you open a workbook that was
already fully calced (as far as the earlier version of Excel was concerned)
but Excel 2000 calced it anyway just because it was from an earlier version.

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?