restrict calculation

J

JE McGimpsey

Harvey Waxman said:
Is there any way to limit calculations to a part of a sheet? Or prevent a
small area from being recalculated?
Click to expand...

You can, sort of, using VBA.

First you'd need to set Calculation to Manual in
Preferences/Calculation, then specify a range to be calculated, e.g.:

Public Sub CalcSelection()
Selection.Calculate
End Sub

or

Public Sub CalcA1toJ10()
Range("A1:J10:).Calculate
End Sub

or

Public Sub CalcAllButB10toC30()
Intersect(ActiveSheet.UsedRange, _
Range("A:A,D:IV,B1:C9,B31:C65536")).Calculate
End Sub

You could call these from an event macro, say the Worksheet_Change event
to calculate "automatically".

The entire sheet will still be calculated if you press CMD-=, or if
Recalculate before Save is set in the preferences.
 
Top