Pivot Table Auto Update Data Source?

K

Ket

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook pivot table design function 6
Pivot table data source 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot table reorganizes when it shouldnt! 3
Auto insert of a pivot table? 1
Apply Filter to source of Pivot Table 2
Pivot Table - Old remaining values for rows 3
Sorting the pivot table field list 4

Top