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

S

steve

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?
 
J

Juan Pablo González

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"
 
Top