Forum Discussion
Not able to refresh PivotTable
Hi, I am running Office 365. This is what I wanted to accomplish. I created a PivotTable from a Excel worksheet. I want to be able to update the data with newer data every month and I want the PivotT...
Hi Lin,
It depends on how you copy/paste your new table on old one. If you select entire new table with headers, copy it, stay on left top header of the first table and paste - you receive new table with automatically generated new name. PivotTable won't recognize it.
If you copy/paste only data, without headers, it shall work. Another option, if you copy/paste entire table with headers, to rename resulting table to Table1 or which name your first table had.