Excel 2003 calculation set to manual after an update was run

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have an user which uses alot of formulas. Updates ran about 2 weeks ago
and since then any spreadsheets she worked on she needs to set the
calculations from manual to automatic.

When she does start a new spreadsheet calculations is set to automatic, but
I need fix the problem with the previous spreadsheets.
 
This setting is saved with the workbook. Just open each of the manual
workbooks, set the mode to Automatic and save the workbook.
 
Calculation mode for all workbooks is governed by the first workbook opened
during a session.

Open one you know has calc mode set to Automatic and subsequent books will open
in that mode.

Save each one after opening.


Gord Dibben MS Excel MVP
 
Back
Top