Forum Discussion
LorneS
Jan 02, 2022Copper Contributor
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...
- Jan 03, 2022
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?
SergeiBaklan
Jan 03, 2022Diamond Contributor
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?
- LorneSJan 03, 2022Copper ContributorThat fixed the problem, thank you! I had no idea that even existed as an option.
Best,
Lorne- SergeiBaklanJan 03, 2022Diamond Contributor
LorneS , you are welcome, glad to help.