| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Filter function with shared workbook
I have a shared workbook with protected sheets. I am trying to filter a
column of information. When I click on the arrow in the header it does not bring up the dialog box for me to choose what to filter on. How can I make this work? Woody |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Filter function with shared workbook
You should select "Allow Filtering" option in the "Protect Sheet" dialog box.
-- CFS "Woody" wrote: I have a shared workbook with protected sheets. I am trying to filter a column of information. When I click on the arrow in the header it does not bring up the dialog box for me to choose what to filter on. How can I make this work? Woody |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Filter function with shared workbook
"CFS" wrote: You should select "Allow Filtering" option in the "Protect Sheet" dialog box. -- CFS "Woody" wrote: Thank you very much. It worked perfectly. I have a shared workbook with protected sheets. I am trying to filter a column of information. When I click on the arrow in the header it does not bring up the dialog box for me to choose what to filter on. How can I make this work? Woody |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| advance filter sustitution in a macro - shared workbook | Excel Worksheet Functions | |||
| shared workbook - macros using advanced filter - substiitution nee | Excel Worksheet Functions | |||
| Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
| Can you disable the save function from a shared workbook | Excel Discussion (Misc queries) | |||
| update pivot in shared shared workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
