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.
Strangely, I think OneDrive may be related to the problem. I set up the spreadsheet on the network for a user and it has been working fine for over a year. However, over the last month or so I notice that she has sometimes ended up saving it to OneDrive and the file she re-opens may be from the network or OneDrive. I'm not sure if that is relevant to the problem or not.