Automatic Calculation Keeps Changing To Manual

[timbo1957]

Hi,

I always have Calculation set to Automatic in Excel. But I have opened up this morning and Book1 opens on start up and the calculation is set to Manual I set it to Automatic and close down reopen and it's back to manual again. Save Book1 with Automatic set close and close down and when I reopen it's back to manual.

Any ideas how I can get it back to Automatic on start up?

[AndyLitch]

Quickest, easiest (and laziest way)
In a code module

Please Login or Register  to view this content.

If it's still switching (which it may) you need to search for the vba code which switches it to manual
1. Switch to VBEIDE (VBA editor)
2. Select a module
3. CTRL-F......................(find)
4. Application.Calculation
5. Select "Entire Project"

......... Step through each instance looking for the key word manual... Where you find one - ensure it has Application.Calculation = xlAutomatic somewhere near the End Sub.

[timbo1957]

Code worked a dream many thanks!

[AndyLitch]

Glad to help