pivot table version issue

G

Guest

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????
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot table wizards 2
pivot table excel 2000 & 2003 1
Pivot Table - Changes 5
Pivot Table - with blank rows 6
Pivot Table Page Break Refresh Problem 0
Pivot Table criteria 2
Excel 2007 pivot table source table 1

Top