Forum Discussion
Excel Bug Causing Corrupt Pivot Table when datasource is added to data model
I can't reproduce these steps:
===
6. Open Excel_BUG_DATAMODEL.xlsm (this file uses the same datasource which has been added to the data model).
7. Note that the filtering, drilled-down fields are the same as the previous file.
8. Refresh pivot table.
9. Pivot table will now "break". You can no longer change your filters, expand/drilldown
===
Open the file, PivotTable has data for Germany and data model for USA. Open any filter, in drop-down I see unselected items for USA (as it shall be, they are taken from data model). Select any few items, PivotTable takes data from data model (for USA) and shows selected items.
On which version of Excel you are?
- I have added an MP4 video demonstration of the bug.
SergeiBaklan I am running Version 2110 (Build 14527.20276)
Thank you for your response! I do feel like perhaps this bug is relatively new as I've been working with pivot tables, data models, measures for a long time and never seemed to notice it before.
With all files downloaded exactly as they are, if I open Excel_BUG_DATAMODEL.xlsm on my computer (or any in my organization), it will not refresh and change the data over to USA data.
Your version is good enough. I'll try bit later to play with configurations if will be able to reproduce the bug.
I was able to confirm that this is a bug based on a recent update. I reverted my version of Office to 16.0.14326.20238 (2108 14326.20238) which was released on 8/25/2021 and the bug is gone. My pivot tables are refreshing normally.
I am going to continue to step up my updates of Office manually build by build to determine what update caused the bug.I reverted my version by following the instructions here:
https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a917-d57e-35a1-f709e3dda841
