R
Ralph
I've not experienced this problem in Excel 2000, but after
upgrading to Excel 2003, there's an odd problem. Has
anyone experience something similar - User error or bug?
The problem:
1. Create pivot table with pivot table 'pages'.
2. The page selection list includes a listing that is not
in the raw data. Refreshing the pivot table wont reset. It
is possible to ascertain from the list order, which data
item is being incorrectly shown.
3. In the raw data, replace the name of the incorrectly
displayed data item with something else (eg 'ABC')
4. refresh the pivot table, and note that the page
selection list correctly displays the new item, ABC.
5. replace ABC with the original name, refresh the pivot
table, and the same problem occurs again!!
Bug?
Any workarounds?
upgrading to Excel 2003, there's an odd problem. Has
anyone experience something similar - User error or bug?
The problem:
1. Create pivot table with pivot table 'pages'.
2. The page selection list includes a listing that is not
in the raw data. Refreshing the pivot table wont reset. It
is possible to ascertain from the list order, which data
item is being incorrectly shown.
3. In the raw data, replace the name of the incorrectly
displayed data item with something else (eg 'ABC')
4. refresh the pivot table, and note that the page
selection list correctly displays the new item, ABC.
5. replace ABC with the original name, refresh the pivot
table, and the same problem occurs again!!
Bug?
Any workarounds?