Filters in Excel 2003 are not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

heather - 21 Jun 2006 18:41 GMT

I have a customer who has a spreadsheet that has many columns. One of the
columns is filtered. The arrow about the column is blue and the other columns
have black arrows. Nothing happens when you click the blue arrow. You get no
options at all, nothing happens. It is the same way on multiple machines. I
have tried to put the info into anothre spreadsheet and the same thing
happens.

Ideas?

Reply to this Message

tim m - 21 Jun 2006 20:28 GMT

not sure if this would affect things but are there any hidden or protected
columns etc that might be botching things up?

> I have a customer who has a spreadsheet that has many columns. One of the
> columns is filtered. The arrow about the column is blue and the other columns
[quoted text clipped - 4 lines]
>
> Ideas?

Reply to this Message

Dave - 21 Jun 2006 22:05 GMT

Heather

Have you tried turning off the Autofilter and then reapplying it?

Dave

>I have a customer who has a spreadsheet that has many columns. One of the
> columns is filtered. The arrow about the column is blue and the other
[quoted text clipped - 7 lines]
>
> Ideas?

Reply to this Message

heather - 22 Jun 2006 19:29 GMT

Dave,
I have tried turning off Autofilter a number of times and it didn't fix
anything.

> Heather
>
[quoted text clipped - 13 lines]
> >
> > Ideas?

Reply to this Message