restrict calculation

[Harvey Waxman]

Is there any way to limit calculations to a part of a sheet? Or prevent a
small area from being recalculated?

OSX

--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me

 

[JE McGimpsey]

Is there any way to limit calculations to a part of a sheet? Or prevent a
small area from being recalculated?

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.