Lost Autofilter option
 

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

Lost Autofilter option
 

scrimmy;

Check to see that the worksheet is not protected.

God Bless

Frank Pytel

http://groups.google.com/group/excel...et-programming

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

Lost Autofilter option
 

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

Lost Autofilter option
 

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

Lost Autofilter option
 

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

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