How do I change an existing range in a pivot table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have new data to a worksheet and I would like the pivot table to include
this data, but I guess when I first created the pivot table the range was set
and now the data is outside this range. How do I change this range?
 
Right click on the Pivot Table and choose "Wizard".

Click "Back" until you can choose the range again. When you have reselected
it, you can just press "Finish"
 
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

Adding to an existing Pivot Table 7
Pivot tables - memory issues - please help 2
Pivot table change data source 1
How can I change the source data reference to another pivot table? 2
Dynamic data ranges in pivot tables 3
Pivot Table Ranges 8
Excel 2007 pivot table source table 1
Pivot Table Data Source 1

Back
Top