Forum Discussion
Excel Pivot Table corruption after loading saved file
Hello community board, I am looking for a solution to an issue I am having with my excel pivot tables no longer existing after loading a saved spread sheet. This doesn't always occur after every tim...
CFerguson I have had similar issues with pivot tables 'breaking' and not updating correctly or at all. I found a work around that usually fixes it without rebuilding the whole table. I remove the Filter category, do a refresh, put the filter back on, and then refresh again. That seems to resync the pivot table to the data. I have to do it so often I actually created a macro to do it for me. lol.
That said I will keep an eye on this thread to see if someone else has better knowledge/answer.
