| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to override a hyperlink | Excel Programming | |||
| Override | Excel Programming | |||
| NosmoQ, good for health, can stop smoking addiction.. | Excel Discussion (Misc queries) | |||
| Override excel's printing dpi setting | Excel Programming | |||
| Override No Zero Values ? | Excel Programming | |||
Linear Mode
