| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Field Items deleted when unchecked in Pivot table
Hello,
I construct a pivot table. When I uncheck certain elements in the data field drop down box, those items get deleted for ever. I have to go back to the pivot chart wizard layout options to include them again. However this is not observed in the case of row, column and page fields. I have so many data items, and at time I would like to do analysis based on only few elements and again i want all the elements back. This seems to be a serious issue. Kindly help me. -- Thanks Anant |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Dragging multiple items into data field | Excel Discussion (Misc queries) | |||
| Pivot Table - untick all items in row field | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Appends a '2' to the field data items | Excel Discussion (Misc queries) | |||
| Finding unique items in data field for pivot tables | Excel Discussion (Misc queries) | |||
| I have deleted the Source data for a pivot table, how do I get it. | Charts and Charting in Excel | |||
Threaded Mode
