pivot-tableexcel-2013dynamics-ax-2012dynamics-ax-2012-r2

Excel PivotTable disappears for one user when file is opened

I have a PivotTable which works perfectly fine for one user, but not for another user.

When this user opens the file, the entire PivotTable design is gone except for the filter fields. The connection to the data works and the PivotTable still exists, because when I click on the filter field cell, I get the PivotTable Fields menu/window on the right-hand side.

Any idea what this could be? I don't want to just rebuild the PivotTable because it works for the other user and the problem may not go away.

Thanks!

Solution

  • Ok, I fixed it.

    The datasource for this PivotTable is using the Dynamics AX add-in and I discovered some behavior where if you build a PivotTable in a given language, then change your language in Dynamics AX itself, the PivotTable design will disappear because the names in the PivotTable field list change and it seems to lose that connection. Change the language back in Dynamics AX and the PivotTable reappears!

    The other user who has no problems uses Dynamics AX in the original language :)