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.

"Chris" wrote:

Using Office 2000...

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