Update data source in Pivot Table

  • Thread starter Thread starter loscherland
  • Start date Start date
L

loscherland

How do you update the data source range in a pivot table???

i.e. I've set up a pivot table for data range A2:H150 in Sheet 1...
Then i paste an extra 50 rows into the spreadsheet & want the pivo
table to update to show the data range A2:H20
 
You must log in or register to reply here.

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

Pivot tables - memory issues - please help 2
Adding to an existing Pivot Table 7
How can I change the source data reference to another pivot table? 2
Pivot table change data source 1
Pivot tables - Editing the data source shared by multiple pivot ta 1
Wait statement in macro 1
pivot table source data expand to new entries when refresh? 4
Pivot table 5

Back
Top