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

Converting excel to PDF, single page converts to multiple HELP! 1
Overriding the calculation state 6
Combobox-calculating issue 8
Opening multiple excel sessions 2
Excel Help - Match column in one worksheet to all worksheets in different workbook 0
Manual Calc in a loop issue 7
Switching calculation to manual using Workbook_open 6
Popup box to enter VLOOKUP value 2

Top