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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Automatic Calculation makes Excel the Active Application 1
Calculation set to automatic switches 3
Excel out of resources - help ! 4
slow calculation of rank and percentile in Excel 2007 3
Manually Calculating Formulas - Resetting totals to zero 1
Excel cell update slowly 2
Excel 2003 / 2007 function 2
Status Bar shows "Calculate", but calculation is set to Automatic 1

Back
Top