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?