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

• From Excel 2000 opening a workbook in Automatic mode that was last calculated (and saved) in an earlier version (which includes earlier versions of the calculation engine) gives you a message saying "Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel". This also causes a Full Calculation rather than a smart recalculation. - 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.