Excel autofilter freezes

V

Vic07

I have a large spreadsheet file of 30+ columns and 9000+ rows. I used the
autofilter function but found that the autofilter stop working after I filter
on one or at most two columns. The autofilter tabs are still there on the
header row but when I click on them, nothing works.

Please help me fix this. I have been having this problem with different
large files and while working on different PCs as well.
 
Top