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?