| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pivot Table Auto Update Data Source?
Hello,
I have a spreadsheet that contains a pivot table sheet1 and the data source is sheet2. I update the data source by adding new rows of data. I then go to the pivot table and re-run the wizard to take into account the new rows of data. Is there an automated way that the pivot table will update with the new rows of data added in sheet2? TIA for any assistance offered. Ket London |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table data | Excel Discussion (Misc queries) | |||
| Pivot and changing External data source | Excel Discussion (Misc queries) | |||
| pivot table in data source order | Excel Discussion (Misc queries) | |||
| ability to auto file column(s) on a pivot table | Excel Worksheet Functions | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
