ExcelBanter - Advanced Filter is grayed out

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Advanced Filter is grayed out (https://www.excelbanter.com/excel-worksheet-functions/47104-advanced-filter-grayed-out.html)

Nick H

Advanced Filter is grayed out

Why can't I use this? Autofilter works fine. I've carefully gone through
help to set up the table and criteria range correctly. Excel 2003 SP1.
Any help will be appreciated.

Debra Dalgleish

Is the workbook shared? Advanced Filter is one of the features that
isn't available in a shared workbook.

Nick H wrote:
Why can't I use this? Autofilter works fine. I've carefully gone through
help to set up the table and criteria range correctly. Excel 2003 SP1.
Any help will be appreciated.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 11:59 AM.