View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scrimmy scrimmy is offline
external usenet poster
 
Posts: 9
Default Lost Autofilter option

That took care of it. Thanks so much for your help!

"Dave Peterson" wrote:

You can reset all the toolbars.

Close excel
Windows start button|Search
look for *.xlb
in hidden folders, too

Rename them all to *.xlbOLD and restart excel to see if it helps.

If it doesn't help, rename them back to *.xlb.

If it does, delete those *.xlbOLD files and recreate any customized toolbars.



scrimmy wrote:

Dave,

Thanks for the repsonse.

I tried your suggestion with no luck. When I click on the filter
selection, the only choices I get a Show All(which is greyed out) and
Advanced Filter.

"Dave Peterson" wrote:

You could try:

Tools|Customize|select the Standard toolbar and click the reset button.

Any customized changes you've done to that toolbar will have to be redone.

scrimmy wrote:

In EXCEL 2003 when I click on Data then Filter, I no longer see the
Autofilter choice. How do I get it back?

--

Dave Peterson


--

Dave Peterson