Autofilter Stops Working

T

Tim2100

I have a fairly large worksheet with around 800 rows of information, and 30
or so columns. I have Auto filter on all of these columns.

Quite often I am finding the Auto filter stops working. The following
happens:- I filter the data as usual, then go to click on the Auto filter
drop down button, it is there but doesn't do anything. The data is still
filtered but the row numbers are no longer colored Blue.

To resolve this I have to remove the auto filter, unhide all rows and set
the filters back up again. This is a HUGE inconvenience, as normally this
will happen when I'm with somebody and trying to get the information out.

Is there anything I can do to stop this???

TIA
Tim.
 
V

Vliegveld

solution is to stop automatically calculate formulas in the option
menu.
manually calculate the links after filtering with f
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter Stops Working!!! 0
Auto Filter - It's broken! Help! (Office '03) 2
auto filter on columns 2
Merged cells disturb autofilter indicator 2
autofilter indicator change 5
Auto Filter Function getting 'stuck' 3
Autofilter not allways working Excel 2003 1
Autofilter query? 1

Top