Hi,

My column and row labels contains more items in the list than it should. I tried searching those values in the sheet that contain the data but only half of them exists in the data.

I have set up a pivot table with a field in row labels and column labels to display a count. I also went to pivot table option > Data and ticked refresh data when opening the file and selected never retain items from deleted from the data source. The data sheet gets updated frequently.


I have tried refresh and pivot cache refresh, both didn't refresh my column and row label list. What causes these undesired values in the column and row labels?

thanks