Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee Flying bat in a marquee

Monday, March 16, 2009

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.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)