No filter buttons

R

Reney Langlois

Hi,
I'm using Excel 2000. Recent problem. When I try to
apply a filter to any table of data, the table header
doesn't show the arrow buttons as part of each header
cell. There is no error message and when I go back to the
Data-Filter menu, the option is selected as normal.
Probably something simple but I can't find it. I've
rebooted and made simple tables to troubleshoot the
problem, but so far nothing.

Thanks much.

Reney
 
D

Dave Peterson

Sometimes those pesky arrows will reappear if you minimize excel's window, then
resize it.

Sometimes if you minimize the worksheet's window and resize it.

Sometimes closing and reopening.

Sometimes removing the filter and reapplying.

I've even deleted that header row and added it back (I _think_ that sometimes
worked.)

Not much help, huh?
 
G

Gord Dibben

Reney

Possible you have Tools>Options>View>Objects "Hide All" checked.


Gord Dibben Excel MVP
 
F

Francis Hayes (The Excel Addict)

Hi Reney,

I use filters a lot and often encounter the same problem. It drives me nuts.
I'll try Dave's suggestions next time. Thanks Dave.

Francis Hayes
www.TheExcelAddict.com
 
R

Reney Langlois

Thanks for the help fellas. I came in this morning, woke
my computer up from sleep mode, worked for a while, then
tried the filter cold and it worked just fine. Amazing, I
tried it at least 10-20 times yesterday after jumping
through all sorts of hoops and today it starts up.

Reney
 
D

Dave Peterson

Frustrating, huh.

I can't reproduce this at will and it seems when it happens, I'm always in a
hurry--so I take the quickest and dirtiest way out--which doesn't help for
future occurrences.
 
Top