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?