R
Rita Leung
The workbook has around 10 pivot tables. When I changed
the source data and hit refresh data in the pivot tables,
the data in the pivot tables got updated. But links in
other worksheets that are linked to the pivot tables did
not get updated. Data in other worksheets could only get
updated when I saved it as a new file. How can it be
solved without saving it as a new file?
the source data and hit refresh data in the pivot tables,
the data in the pivot tables got updated. But links in
other worksheets that are linked to the pivot tables did
not get updated. Data in other worksheets could only get
updated when I saved it as a new file. How can it be
solved without saving it as a new file?