Filters in Excel 2003

S

SMonczka

I am using Filters in Excel 2003.

Every cell in sheet B is linked to every cell in sheet A. That way I
can alter data in B without corrupting the original data in A. I then
highlight the cells in B that I want to assign a filter to and select
Advanced Filter. I have no criteria so I do not set that. I click OK.
I then select Filter again and this time select Auto Filter. Drop
down arrows appear at the top of my columns. Great, no problems so
far, I then select from the drop down list the criteria that I want to
filter. Again no problems, my list filters correctly.

But once I have done this I can not use the drop down lists to make
another filter or select all to see all my data. Ether the drop down
lists are not clickable or they disappear.

What am I doing wrong?

Thanks
Steve
 
I

igorek

I believe that you are doing everythig correctly. I have
an ancounter like that before. I think it has to do with
Excel not being able to handle large tables. Try reducing
the number of rows and try again
 

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

Filter drop down box in pivot table 1
VBA: How can I use a string variable as autofilter criteria? 4
Macro to copy value in field and insert it into filter 2
I want to extract info from a database on sheet1 to sheet2. 6
Filling cells with filtered data to another sheet. 2
Filtered results and printing 1
Exel Auto Filter 1
Filtered drop down list 2

Top