Advanced Filter

[Guest]

Using Office 2000...

Trying to use an advanced filter to filter only the unique records... The
option is always grayed out... why?

 

[Bob Phillips]

Perhaps you are using a shared workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

I have come across this when using a shared workbook.
If this is the case with you making the workbook exclusive should make the
advanced filter available.