manual vs. automatic calculation

K

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top