Forum Discussion
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...
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.