XL2003. I use often use Advanced Filter, but I have one file from a user that
will not play. When I put an advanced filter on it, it returns the entire
table, not just the filtered bits. There are no blank cells in the table, I
have copied it and pasted just the values, I've multiple-checked I'm setting
up the AF correctly. I'm usually filtering in place, but I've tried filtering
it to another place and the entire table goes there. It works fine as a List
and with Autofilter. Please can anyone suggest what setting I am missing to
make it work with Advanced Filter?

Update: If I only have criteria in Row 2, and select just Row 1 (titles) plus
the Row-2 criteria range it works. I was selecting all Rows 1-3. This only
works if I have criteria in both Rows 2 and 3. If I have 'fixed' this I no
longer need help with the problem, but I am still puzzled.

"Jonathan589" wrote:

> XL2003. I use often use Advanced Filter, but I have one file from a user that
> will not play. When I put an advanced filter on it, it returns the entire
> table, not just the filtered bits. There are no blank cells in the table, I
> have copied it and pasted just the values, I've multiple-checked I'm setting
> up the AF correctly. I'm usually filtering in place, but I've tried filtering
> it to another place and the entire table goes there. It works fine as a List
> and with Autofilter. Please can anyone suggest what setting I am missing to
> make it work with Advanced Filter?