ExcelBanter - Using Filter function with shared workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Using Filter function with shared workbook (https://www.excelbanter.com/excel-discussion-misc-queries/217521-using-filter-function-shared-workbook.html)

Woody

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

CFS

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

Woody

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

All times are GMT +1. The time now is 08:15 PM.