Pivot Table in excel 2016 does not allow to change data source

[TEEPK]

Dear All,
Anyone encounter this issue ?

I just switch to Excel 2016 and using the pivot Table.

previously I have file with pivot table using Excel 2013.
When i open this file in excel 2016, it does not allow me to change the data source.
Everytime I change it, it goes back to the original data source reading (The data is in the same workbook).
Is it bug ?

Anyone can help ?

 

[mse330]

I have upgraded to 2016 & it is working fine. Try to make a new pivot table in a different sheet & see if the same issue persist.

 

[JGrant]

TEEPK - did you ever find an answer for this? I have been experiencing the same thing since installing 2016.