Pivot tables hide info drop down menu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table and I need to hide data on the worksheet. When I access
the drop down menu, all of the categories do not appear on the list. How do
I get all items to appear in the drop down menu? What causes this?
 
If this is a field in the page area, some items may be hidden.
Right-click on the field button, and choose Field Settings
In the Hide Items list, click on any selected items, to unselect them.
Click OK
 
You must log in or register to reply here.

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 Table Refresh Not Updating Drop Down List 1
Link Drop Down with Pivot Table 2
Pivot Item Displaying Incorrect Value? 1
Drop Down Menu AutoPopulate Contact Info? 2
DROP DOWN MENU "source" 5
Pivot Tables- SQL Alias' & Field Lists 1
How to clear data in pivot table? 4
pivot table question 1

Back
Top