My Excel 2003 AutoFilter is not working properly.

E

Emily

I have been using Excel forever. I train my company on all aspects of the
program. Lately I have been having issues with the AutoFilter on a few
select workbooks. These workbooks are not necessarily huge (less that 2M).

Here's my Excel 2003 problem - no matter how I activate the AutoFilter...
whether I highlight an entire column, a set of data, or a row of data, the
filter does not work properly. The arrows appear… but when I try to click on
the arrows they do not "click" and no data is shown. If I close Excel and
re-open the same workbook it sometimes will allow me to filter once or twice
but then it stops working. When it stops working after I have filtered and I
unselect "AutoFilter" under the Data menu the data does not "expand" it
remains "filtered", the filter arrows disappear, and I have to unhide rows to
expand my list manually. All other aspects of the spreadsheet work properly.
It does not “lock up†it is only the AutoFilter that does not work properly.
Is that weird or what? How can I fix this?
 
J

Jim Sheehan

Hi Emily,

I've just run into this problem as well with my Excel 2003, exactly as you
describe. It's really cramping my work, have you found a resolution?

Thanks,

Jim
 

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

Top