Calculation Options
 

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

--
Message posted from http://www.ExcelForum.com

Calculation Options
 

Place the following line of code in the "Sub Workbook_Open
()" procedure.

Application.Calculation = xlManual

Michael

-----Original Message-----
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 using
this tool otherwise a normal machine will lock up. Is
there a macro or
a way to default manual calculation when this workbook
is opened?

You advice is appreciated.


---
Message posted from http://www.ExcelForum.com/

.

Calculation Options
 

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

"dmckean" wrote in message
...
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 using
this tool otherwise a normal machine will lock up. Is there a macro or
a way to default manual calculation when this workbook is opened?

You advice is appreciated.


---
Message posted from http://www.ExcelForum.com/