Spreadsheet changes from auto calc to manual calc - HELP!

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

Guest

We send out spreadsheet templates to staff for budgeting. Sometimes, when
the completed budget spreadsheet comes back, the Calculation has changed from
Automatic to Manual. How can this happen? I don't believe the user would
intentionally change it. Any suggestions on how to fix this would be
appreciated!
 
The setting for calculation is taken from the first workbook opened. So if
you open a workbook with manual calculation and then open one which had
automatic calculation, it will change to manual.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
I've been through this one myself. Place this in the
workbook open event to ensure opening in automatic mode:

Application.Calculation = xlCalculationAutomatic

Mike
 
Back
Top