Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disappearing Data Items on Pivot Table -Updated Question
I have just created a pivot table with two column fields, 1 row field and six
data fields. I can select on the column and row fields but when i try to select items on the data field, the unselected items disappear when i go back into drop down menu on data field to make another selection. The only way to get it back is to add the field to the data. Is there a way of fixing the fields in data. Yours desperately George |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to clear data references in pivot table report | Charts and Charting in Excel | |||
How do I get a pivot table to sort based on the data items sectio. | Excel Worksheet Functions | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
Pivot Table Data | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |