How to add more data to a PivotTable?

Occasional Visitor

Hi everyone!


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?

Thank you very much,




1 Reply

Hi Scot,


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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies