Spreadsheet changes from auto calc to manual calc - HELP!

[Teija]

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!

 

[Niek Otten]

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

 

[Mike]

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

Application.Calculation = xlCalculationAutomatic

Mike