| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter Does Not Work
I am in Excel 2000 and can't get my autofilter to work on my spreadsheet.
The only option available is "advanced filter." Does anybody know why it is not working? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter Does Not Work
Hi Michelle
Do you have Freeze panes switched on? I can't remember whether it was after XL2000, or after XL97 when this was fixed. Try switching it off. -- Regards Roger Govier "Michelle" wrote in message ... I am in Excel 2000 and can't get my autofilter to work on my spreadsheet. The only option available is "advanced filter." Does anybody know why it is not working? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter Does Not Work
Roger,
Thanks. I tried your suggestion. It didn't work. If I copy the worksheet into a new spreadsheet and save it, I don't have this issue anymore. Does anyone else have any suggestions? Thanks. Michelle "Roger Govier" wrote: Hi Michelle Do you have Freeze panes switched on? I can't remember whether it was after XL2000, or after XL97 when this was fixed. Try switching it off. -- Regards Roger Govier "Michelle" wrote in message ... I am in Excel 2000 and can't get my autofilter to work on my spreadsheet. The only option available is "advanced filter." Does anybody know why it is not working? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter Does Not Work
Got my answer.
Tools Options View - Options - Show All Thanks. "Michelle" wrote: Roger, Thanks. I tried your suggestion. It didn't work. If I copy the worksheet into a new spreadsheet and save it, I don't have this issue anymore. Does anyone else have any suggestions? Thanks. Michelle "Roger Govier" wrote: Hi Michelle Do you have Freeze panes switched on? I can't remember whether it was after XL2000, or after XL97 when this was fixed. Try switching it off. -- Regards Roger Govier "Michelle" wrote in message ... I am in Excel 2000 and can't get my autofilter to work on my spreadsheet. The only option available is "advanced filter." Does anybody know why it is not working? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
| Auto Filter does not work with embedded objects | Excel Worksheet Functions | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
| Auto Filter will not work in a new worksheet | Excel Worksheet Functions | |||
Linear Mode
