Excel 2013 - Undo PivotChart changes connected to Powerpivot Datamodel is cutting off datasource name last digit when have more than 10 charts (Network Steve Forum)

Excel 2013 - Undo PivotChart changes connected to Powerpivot Datamodel is cutting off datasource name last digit when have more than 10 charts

Can you confirm its a bug in Excel 2013?

- Create some tables and add them to the data model (powerpivot).

- Create more than 10 PivotCharts connecting directly to the powerpivot (ThisWorkBookDataModel)

- Go to the last Chart created that is connected to the Datamodel (i.e Datasource = PivotChartTable10)

- Add or remove any field

- Click UNDO or CTRL-Z

- Right click the Chart you changed->Select Data and check the "Chart Data Range". You will see that the Data Source changed from:

PivotChartTable10

PivotChartTable1

I tried that on larger sheet and got same results. i.e changed a chart that was linked to PivotChartTable55 and it renamed to PivotChartTable5 breaking all the fields.

Thanks,

June 9th, 2015 2:13pm

This topic is archived. No further replies will be accepted.