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?
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-f709e3dda841SergeiBaklan I can confirm that this bug first appeared in Version 2109 (Build 14430.20234) released on 9/28/2021. I have attached a video of the pivot table being refreshed in Version 2108 (Build 14326.20404) that WORKS PROPERLY. Then a video of the pivot table being refreshed in Version 2109 (Build 14430.20234) that DOES NOT WORK PROPERLY and results in a corrupted pivot table.
Thank you so much for asking me what version I was running. I have been trying to figure out what I've done wrong or a workaround for weeks. You question about the version at least led me to question whether this was caused by a build update.
I'm not sure where to go from here with this bug. But at least I know what I'm dealing with.