issue with Pivot table 'Change data source'

New Contributor

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?



2 Replies

my office: office 365  Version : 18.2008.12711.0

@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.