Feb 10 2021 02:55 AM
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
Feb 10 2021 06:00 PM
my office: office 365 Version : 18.2008.12711.0
Feb 11 2021 01:38 AM
@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.