Filters in Excel 2003

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 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


-----Original Message-----
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
.