Then set the whole workbook to manual recalculation. Same tab, different
radio button.
--
Brevity is the soul of wit.


"Lynn" wrote:

I made the change and it still recalculates when I change the filter.
Someone help before I go insane. Lynn

"Dave F" wrote:

Go to Tools--Options--Calculation and set calculation to automatic except for
tables.

Dave
--
Brevity is the soul of wit.


"Lynn" wrote:

I have a file with a lot of calculations and everytime I change the filter
criteria it recalculates. This is driving me crazy. I've changed the
subtotal calculations to sums. Is there anything else that would cause it to
recalculate when the filter is changed?