Pivot Tables

B

Big Red

I have an existing pivot table and charts. I have added a new column of data
to the pivot table data tab. However, this column is not pulling into the
pivot table when I Refresh Data. Is there a way to incorporate the
additional column of data into the pivot table without completly starting
over with the creation of a new pivot table?
 
N

Nick Hodge

Big Red

Click in the pivot table and on the pivot table toolbar invoke the wizard,
press back instead of next and reset the range. You may wish to define a
range name (Edit>Define...>Name), you can then use and change this and the
range used for the pivot will reset automatically.

If you insert rows, columns the data range should expand automatically.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
P

Peo Sjoblom

Right click in the pivot table and select wizard, click back button and
change the range to include the new column, click next then add the new
header where you want it to be in the layout, then click finish


Regards,

Peo Sjoblom
 
Top