Excel 2003 has just been installed on my computer and I was trying to use the
advanced filter feature prior to creating a pivot table fromt he filtered
data.  The problem is that advanced filter does not seem to be working at
all.  The list is not filtered based on the criteria.  I have reviewed the
"Filter by using advanced criteria" in help and tried to duplicate the
example, without success. What is wrong??

Type    Salesperson    Sales
    =Davolio   
       
       
       
Data       
Type    Salesperson    Sales
Beverages    Suyana    5122
Meat    Davolio    450
Produce    Buchanan    6328
Produce    Davolio    6544

Result of running advanced filter       
Type    Salesperson    Sales
Beverages    Suyana    5122
Meat    Davolio    450
Produce    Buchanan    6328
Produce    Davolio    6544