Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFilter 2003 Excel Protected Sheet
I followed instruction to protect sheet and allow autofilter but still Excel
2003 sheet will not give me option to autofilter. I used tools, protection, protect sheet. Next I selected Use AutoFilter and clicked OK. But the only thing it allows me to do is Advanced Filter. Is there something else I have to change that may be set wrong by default somewhere? I know this should work. -- Brian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFilter 2003 Excel Protected Sheet
The worksheet already has to have the autofilter arrows applied when you protect
the sheet. Could that have been your problem? bdehning wrote: I followed instruction to protect sheet and allow autofilter but still Excel 2003 sheet will not give me option to autofilter. I used tools, protection, protect sheet. Next I selected Use AutoFilter and clicked OK. But the only thing it allows me to do is Advanced Filter. Is there something else I have to change that may be set wrong by default somewhere? I know this should work. -- Brian -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFilter 2003 Excel Protected Sheet
Yes, I have made sure that all cells are not locked as well as I have got
sort to work when protected. Still no luck on Autofilter! -- Brian "bdehning" wrote: I followed instruction to protect sheet and allow autofilter but still Excel 2003 sheet will not give me option to autofilter. I used tools, protection, protect sheet. Next I selected Use AutoFilter and clicked OK. But the only thing it allows me to do is Advanced Filter. Is there something else I have to change that may be set wrong by default somewhere? I know this should work. -- Brian |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoFilter 2003 Excel Protected Sheet
That was it.
Thank You. -- Brian "Dave Peterson" wrote: The worksheet already has to have the autofilter arrows applied when you protect the sheet. Could that have been your problem? bdehning wrote: I followed instruction to protect sheet and allow autofilter but still Excel 2003 sheet will not give me option to autofilter. I used tools, protection, protect sheet. Next I selected Use AutoFilter and clicked OK. But the only thing it allows me to do is Advanced Filter. Is there something else I have to change that may be set wrong by default somewhere? I know this should work. -- Brian -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Help in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
spell check in an Excel protected sheet | Excel Discussion (Misc queries) |