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.
everything was working fine until I updated the Database table
I added few rows of data below the Database table and resized the table to cover the new added data below
the issue is now all my pivot tables doesn't return the data with the new included rows in the database table.
please help if you have information leading to solution for this case
6 Replies
Posting this for future users looking for the same answer
https://www.extendoffice.com/documents/excel/4238-excel-clear-filter-cache.html
I suspect you didn't resize the table.
Hi Detlef. I resized the table for sure 🙂 more than one time just to make sure and it was not the problem
keep in mind when I do another pivot table on the same table it returns the data right!
- Check whether the table range matches the data source in the pivot table.
