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
|