Datafields disappear in PIVOT table

M

mtpsuresh

Joined
Mar 9, 2007
Messages
1
Reaction score
0
Created a Excel 2003 pivot table by placing items in the Page area and the Data area. In the Datafields Data drop down, If I uncheck Show All, then check a selected few items and see the results. Then I go to the Data drop down and Show All and the few items I previously selected are the only items available. If I immediately go to Edit->Undo, I can get the entire list back. Otherwise I Can't Undo or ctrl-Z. How do I get my full list back?


Thanks
MtpSuresh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables - using .AutoShow 1
Macro to clear then reinsert pivot table datafield 1
Link Drop Down list with Pivot Table 3
Link Drop Down list with PIVOT Table in Excel 2003 0
Using VBA on Excel Pivot Tables 3
pivot table not getting updated 2
List of Displayed Pivot Items 1
dynamic pivot table selection 1

Top