Try right-clicking within the pivot table and selecting Refresh Data

" wrote:

Hello, my excel file manages expences and has columns for date, amount,
account and type of expence. This one for example had values like
clothes, food, toys and so on.
As I understand the pivot "row hide menu" gets items from the data
page values so I'll find correctly clothes, food, toys....and I can
select on or more of them to be displayed in my pivot.

PROBLEM: The question is...when I cancel all the expences for food I
expect to have "food" item cancelled also from the hide menu...but it
keeps staying there and that is very annoying because I suppose the
number of items will increase with the time to an amount hard to
manage.

The page field has a property to hide the items from the "hide menu"
drop down list while the row and column fields haven't.

Any idea how to hide items or update them so to automatically sync with
the values of the main sheet?

English is not my language but I hope I was clear enough to make you
understand what is my question!!!!

Thank you,
Ataru