Grouping of sheets and enabling/disabling Autocalcs

[pcomet]

I have a workbook that is a rollup of analysis on individual assets. There are numerous sheets and many conditional sumproduct summation formulas within each that are slowing down calcs (i believe). I want to be able to turn off the calcs on sheets i am not working on.

The workbook contains analysis on 5 assets. Each asset has 5 sheets related to the asset. Within each asset group, there are 2 data entry sheets (simple sumif/countif/average if in these). The other 3 sheets contain inputs contain heavy formulas.

There are 5 additional summary output sheet that summarize the information for each of the 5 assets. The 5 summary output sheets have IRR and conditional sumproduct summation formulas.

My goal is to group the sheets related to each of the 5 assets and group the 5 summary sheets, so i can only have calcs enabled on an individual asset or on the output sheets.

Any suggestions?

 

[OaklandJim]

Try this: set recalc to Manual and add this code to every worksheet's events. Hopefully the calc. latency isn't too sluggish.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
  Me.UsedRange.Calculate
End Sub