How to add more data to a PivotTable?
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, Scot