Excel Pivot Table Trouble

D

Denise

When working with a pivot table, if I uncheck an item in
the dropdown list, the item disappears completely. The
only way to get it back is to click the "undo" button.

Your assistance is greatly appeciated.
 
D

Debra Dalgleish

If you uncheck an item in the data dropdown list, it's removed from the
pivot table. To get it back, you can drag it in from the field list.

Items from the Row and Column dropdown lists should remain on list
though, even if they're unchecked.
 

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

Top