Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |