View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anant Anant is offline
external usenet poster
 
Posts: 4
Default 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