Excel global setting for all workbooks? Calculation Automatic

[Guest]

To All,

I have a workbook running VBA code that "causes all my" workbooks to change
from Calculation Automatic to Calculation Manual... until I can get to the
bottom of this problem...

Is there a global setting "effecting all workbooks" that will reset the
Calculation back to Automatic. Or is a macro "effecting all workbooks"
required to achieve this - if so, could you please supply the code achieving
this result?

Thanks, Ben

 

[Pete_UK]

If you open a workbook which has calculation set to manual, then Excel
will take this setting and apply it to all other workbooks opened in
that session. You can set it back to Automatic by Tools | Options |
Calculation (tab) then click Automatic and OK - save your workbook
with this setting. One way to avoid this happening is to close Excel
before opening a different workbook, but a better approach is to amend
the offending macro such that calculation is re-set to automatic at
the end.

Hope this helps.

Pete