Is Auto Recalc turned on when you are using a global filter. It is automatically turned on for a local filter