I know that you can stop a whole workbook from being automatically
calculated but can it be done for just one sheet?


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

Hi

You can simply replace all formulas with their values (PasteSpecial.Values).
Of-course there is no way back later, but it's the only way, I'm afrayd.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"ianripping " wrote in message
...
I know that you can stop a whole workbook from being automatically
calculated but can it be done for just one sheet?


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

You can do this by setting Worksheet("DontCalc").enablecalculation to false.
Then automatic calculation will recalc all other sheets.
To recalc "DontCalc" you have to reset .enablecalculation to True.

Note that .Enablecalculation is not normally saved with the workbook so you
have to set it each time.

You can also use this technique to only calculate the active workbook etc
(see FastExcel V2 user guide).

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

Arvi Laanemets" wrote in message
...
Hi

You can simply replace all formulas with their values
(PasteSpecial.Values).
Of-course there is no way back later, but it's the only way, I'm afrayd.


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"ianripping " wrote in message
...
I know that you can stop a whole workbook from being automatically
calculated but can it be done for just one sheet?


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