Forum Discussion
Excel Pivot Table has stopped interacting
I have a pivot table connected toa data model which was working fine for a year or more but recently it has stopped interacting. When I press refresh, the data gets updated (I can see new transaction...
This exact same issue has happened to me. Multiple files, all experiencing the same thing. Horribly inconvenient.
A very temporary workaround is to upload to OneDrive, manipulate the filter/pivot tables online on OneDrive, and then export a copy.
Rebuilding the data model/tables is something that would be very time consuming so I am hoping to avoid at this point.
A very temporary workaround is to upload to OneDrive, manipulate the filter/pivot tables online on OneDrive, and then export a copy.
Rebuilding the data model/tables is something that would be very time consuming so I am hoping to avoid at this point.
When I looked at the data model, I could see that the data had updated successfully (which I initally had presumed was the problem). Did you find the same thing?