Forum Discussion
pivot table returning old data even after refreshing and applying auto refresh!
greetings Guys I have a dashboard with more than 10 charts and some tables... this dashboard returns its data from a dozen of pivot tables. the pivot tables gets their data from Database sheet....
Posting this for future users looking for the same answer
https://www.extendoffice.com/documents/excel/4238-excel-clear-filter-cache.html