Nov 17 2021 09:23 AM
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 transactions in the data model) but the pivot table does not change. Also, it does not respond to slicer or filter selections. No error message or warning appears. It has stopped working on two different machines using Office 365 (verson 2110) but it works ok on an older machine with Excel 2016.
I've never had this issue with pivot table before.
Anyone encounter and solve this problem before?
Thanks in advance.
Oliver
Nov 17 2021 09:57 AM
Nov 17 2021 12:27 PM
Nov 17 2021 01:04 PM
Nov 17 2021 01:07 PM
Nov 18 2021 08:46 AM