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?