Calculation Options

  • Thread starter Thread starter dmckean
  • Start date Start date
D

dmckean

I have a rather large workbook (85 meg) that I've built for a client.
It is necessary that automatic calculation be turned OFF when usin
this tool otherwise a normal machine will lock up. Is there a macro o
a way to default manual calculation when this workbook is opened?

You advice is appreciated
 
Place the following line of code in the "Sub Workbook_Open
()" procedure.

Application.Calculation = xlManual

Michael
 
Excel sets its application-level initial calculation mode from the first
workbook opened, and stores the current calculation mode in a workbook when
it is saved.

So assuming you have saved the workbook in manual mode everything will be ok
if it is the first workbook opened.

If it is the second workbook opened and Excel is in automatic mode it will
be recalculated on open. Any macro contained in the workbook open event will
not be executed until after it has opened and calculated: so a complete
solution is difficult to achieve.
One partial solution is to use a workbook.open macro to set calculation to
manual.

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
Back
Top