Override Excel's Heroin Addiction to Calculating

P

Paige

If I open a file that includes code (Application.Calculation =
xlCalculationAutomatic) in ThisWorkbookthat changes calc to manual upon
opening, it still calculates; likewise, if I use SaveAs in a macro, even if I
explicitly change calc to manual first, once it starts saving, it
recalculates. How do I stop Excel from calculating when a file is opened and
saved? P.S. Am using Excel 2003.
 
J

Jim Thomlinson

The before save part is easy...

Application.CalculateBeforeSave = False

I did not follow you on the first part...
 
P

Paige

Yikes, I'm embarrased! Thanks, Jim. The other part was how to stop it from
calculating when opening a file. I tried putting Application.Calculation =
xlCalculationManual in ThisWorkbook, but it still calculates when the file is
opened.
 
C

Charles Williams

Excel calculates before any events fire ...
so the onl;y way is to switch to Manual before opening the workbook ...
adding a workbook that is in Manual mode to XLStart will work.


Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 

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

Overriding the calculation state 6
Opening multiple excel sessions 2
Tabels and calculation methods 3
Problem with open_workbook sub 6
SaveAs and File Exists 1
VBA to "answer" spesific msg box 1
XL2007 - Known problem? - Driving me crazy. 18
date format changes when I save to CSV via a macro 1

Top