Forum Discussion
OliverBuckley
Nov 17, 2021Copper Contributor
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...
Detlef_Lewin
Nov 17, 2021Silver Contributor
I would suggest to rebuild the pivot table.
OliverBuckley
Nov 17, 2021Copper Contributor
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.