I have a tab in my Excel spreadsheet called Details. On this tab is a bunch of raw data. Then I have a second tab that is my PivotTable. It magically parses out data in a way I can't explain, but it's awesome.
My problem is that every week I get more data in the same format and I want to add it to the current PivotTable. When I tried to copy and paste the data from the second Excel spreadsheet into the Details tab of the first Excel spreadsheet, the PivotTable didn't update. Does anyone know if this is possible?
Stay on Pivot Table and on ribbon PivotTable Tools->Analyse-Change Data Source and update your range from here. If you din't add data to data model creating the PivotTable it just updates your PivotTable, otherwise it could require to rebuild it.
In general it's better to use Excel tables or dynamic named ranges for your source data.