Stop one sheet from calculating.

I

ianripping

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

Arvi Laanemets

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.
 
C

Charles Williams

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 said:
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.
Click to expand...
 
Top