Override Excel's Heroin Addiction to Calculating
 

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.

Override Excel's Heroin Addiction to Calculating
 

The before save part is easy...

Application.CalculateBeforeSave = False

I did not follow you on the first part...
--
HTH...

Jim Thomlinson


"Paige" wrote:

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.

Override Excel's Heroin Addiction to Calculating
 

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.


"Jim Thomlinson" wrote:

The before save part is easy...

Application.CalculateBeforeSave = False

I did not follow you on the first part...
--
HTH...

Jim Thomlinson


"Paige" wrote:

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.

Override Excel's Heroin Addiction to Calculating
 

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

"Paige" wrote in message
...
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.


"Jim Thomlinson" wrote:

The before save part is easy...

Application.CalculateBeforeSave = False

I did not follow you on the first part...
--
HTH...

Jim Thomlinson


"Paige" wrote:

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.

Override Excel's Heroin Addiction to Calculating
 

Thanks guys; this will definitely resolve my issues. Appreciate the help!

"Charles Williams" wrote:

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

"Paige" wrote in message
...
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.


"Jim Thomlinson" wrote:

The before save part is easy...

Application.CalculateBeforeSave = False

I did not follow you on the first part...
--
HTH...

Jim Thomlinson


"Paige" wrote:

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.