I have a column of data linked to values in loads of other worksheets.

I need to place an advanced filter on the column to identify unique values only.

The advanced filter gives an error "advanced filter requires more than one row of data." But there are hundreds of rows of data!

Does the filter not recognise linked cells?

How can I get around this?