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?