Forum Discussion
Solved
pivot table duplicate drop down
I have a strange situation which I have been unable to resolve. I have a single database, no queries or connections, everything located in a single table on a single sheet. From this, on 5 tabs, I ha...
Perhaps you have cached PivotTable. If creating PivotTable you add data to data model; or clean cache using cached PivotTable (as here Delete & Clear Pivot Table Cache | MyExcelOnline ), do you have the same?
I suppose you are using 'Sort & Filter' directly on the headings of your table? Happens in such cases.
1. see if any of the cells are in white text
2. see below your last data, if there are more data way below.
Can you share your file to be more sure?
1. see if any of the cells are in white text
2. see below your last data, if there are more data way below.
Can you share your file to be more sure?