Forum Discussion
Excel Bug Causing Corrupt Pivot Table when datasource is added to data model
I believe I've come across a bug in Excel and I'm not sure where to go with it. I'm hoping to find a workaround, but I'd at least like to see if anybody can actually confirm that this is a bug. Thi...
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.