Automatic Calculation

[peacelittleone]

Is there a way to turn off automatic calculation for just one workbook?

I believe the default behavior turns auto calc off for all workbooks.

TIA!

 

[Guest]

Hi

If you save a workbook with Manual Calc, Excel will remember it. But whether
the Excel session is set to Manual or Automatic is determined by the first
book you open.

Andy.

"peacelittleone"

 

[Dave Peterson]

It's an application setting. You could have just one workbook open, though????

 

[Guest]

To the best of my knowledge there is not.

In a controlled setting, you might turn it off for the application, then
use the selectionchange event in all the other workbooks to trigger a
calculation of that workbook.


Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

 

[peacelittleone]

Thank you all for your responses.

Unfortunately, I usually have 3-5 workbooks open at the same time and
there is only one where I want to have auto calc off.

 

[peacelittleone]

Thank you all for your responses.

Unfortunately, I usually have 3-5 workbooks open at the same time an
there is only one where I want to have auto calc off

 

[peacelittleone]

Thank you all for your responses.

Unfortunately, I usually have 3-5 workbooks open at the same time an
there is only one where I want to have auto calc off