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...
I would suggest to rebuild the pivot table.
Thanks for the suggestion - rebuild seems to have worked but it isn't a feasible solution and presumably it could happen again. I need to understand what has happened so i can prevent it happening again.