manual vs. automatic calculation

[Kaiser]

This works well everytime I open a file and hence an instance of Excel
opens. However, if I first open a small file such that my
personal.xls file switches calculation to automatic, then if I open a
very big file, Excel automatically starts to calculate the file & only
after that does it switch calculation to manual. Any workarounds for
this?

Thanks a lot,
Mehul

 

[Charles Williams]

The problem is that in Automatic mode Excel recalculates the file before any
events fire, so there is no way to prevent this using any code contained in
the large workbook.
The only (partial) workaround is to make sure that Excel always starts in
Manual mode (use Personal.xls to set to Manual), then have code in the small
workbooks to switch to automatic.

Or only ever open a single workbook at a time.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com