issue with Pivot table 'Change data source'

[NewExcel650]

hi All,

i encounter an issue when i want to update source data range for current Pivot table.  i google and find i could use 'Change data source' to change data range and addin more data.  But when i try it on my excel files, after i click OK, the pivot table is gone!!!!!  i have to redo my pivot table, which is not what i want.

anyone encounter same issue as me?  how to settle this issue?

thanks

[#2]

my office: office 365  Version : 18.2008.12711.0

[#3]

@NewExcel650 If you change data source from the pivot table sheet itself, it will just just auto modifying the current pivot table instead of gone.