Shanehughes
New Member
- Joined
- Oct 19, 2006
- Messages
- 5
Hi Guys
My problem is an intermittent failure of the AutoFilter function and subtotal formula
About every third occasion when I attempt to release the filter(s) they won’t release. The only cure is to switch off AutoFilter, block the hidden columns and select unhide from the format menu. Even after this, with all data in view, the subtotal formula at the top of my sheet won’t recalculate and continues to show the filtered values. To clear the subtotal problem I have to copy paste the same formula from adjacent columns
It is a complex worksheet with many tabs, but basically only consisting of v & h lookups, if statements and array lookups. None of the formulas are linked to external sheets
Have any of you experienced these problems?
My problem is an intermittent failure of the AutoFilter function and subtotal formula
About every third occasion when I attempt to release the filter(s) they won’t release. The only cure is to switch off AutoFilter, block the hidden columns and select unhide from the format menu. Even after this, with all data in view, the subtotal formula at the top of my sheet won’t recalculate and continues to show the filtered values. To clear the subtotal problem I have to copy paste the same formula from adjacent columns
It is a complex worksheet with many tabs, but basically only consisting of v & h lookups, if statements and array lookups. None of the formulas are linked to external sheets
Have any of you experienced these problems?