Forum Discussion
Excel Bug Causing Corrupt Pivot Table when datasource is added to data model
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.
- This bug appears to have been resolved in update 14527.20312 and 14701.20226 released early December 2021.