Control which sheets get Recalc?
 

Hi Chuck,

You can use Worksheet.EnableCalculation=false to stop the large sheet
calculating.
This property is not stored in the workbook, so you need to reset it each
time the workbook is opened, and the workbook needs to be in Manual
calculation mode.

when you want to calculate the large sheet you set its Enablecalculation
property to true and press F9

The down side to this method is that when you reset enablecalculation to
true ALL the formulae on that sheet get 'dirtied' so the next recalc is a
Full calculation for that sheet (which will tend to make it even slower!)

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

"CLR" wrote in message
...
Hi All......
I have a 9MB workbook with about 50 sheets that takes a long time to
recalculate. Only one sheet is large, containing some 15,000 rows of
data.
This large sheet never gets changed during the regular operations of the
workbook.....only when the Administrator directly manually addresses this
sheet. Might it be possible with Worksheet Activate/Deactivate macros to
turn off any Recalcs on this sheet, (or any others), unless it is active?
I
in hopes this might speed up my overall Recalc time, maybe?

TIA
Vaya con Dios,
Chuck, CABGx3