Autofilter Question

[veryeavy]

Hi All,

This is a problem I have had for ages - since the "fix" is easy I haven't
asked previously.

I find that Autofilter periodically seizes up and refuses to "Show
All", with one file being particularly recalcitrant (but not always) in this
regard. Other files (all largish) also misbehave. Spanking has not proved
effective, but has been therapeutic.

The solution is to:

- remove the autofilter
- select all rows and unhide the hidden rows
- reapply the filter

Any ideas on possible causes?

Thanks in Advance,

Matt