pivot table version issue
 

A client created a pivot table in Excel 2003. In 2003, the filter dropdown
arrows are visible and working. Anyone that opens the file in Excel 2000 does
not see the dropdown filters. When you click on the pivot table, Excel does
recognize it as a pivot table since the ptable toolbar is active and I am
able to access the layout, etc. I copied the data sheet to a new file (using
Excel 2003 - different PC), recreated the pivot table and now users with
Excel 2000 can see the dropdowns. It is either a setting on the client's PC
or a setting within the pivot table itself - but I can't for the life of me
figure out what setting is different. Any ideas????
--
maryj

I found a post from Debra Dalgleish - Tools, options, View, Objects - show all
Thanks Debra!
--
maryj


"maryj" wrote:

A client created a pivot table in Excel 2003. In 2003, the filter dropdown
arrows are visible and working. Anyone that opens the file in Excel 2000 does
not see the dropdown filters. When you click on the pivot table, Excel does
recognize it as a pivot table since the ptable toolbar is active and I am
able to access the layout, etc. I copied the data sheet to a new file (using
Excel 2003 - different PC), recreated the pivot table and now users with
Excel 2000 can see the dropdowns. It is either a setting on the client's PC
or a setting within the pivot table itself - but I can't for the life of me
figure out what setting is different. Any ideas????
--
maryj