Pivot table

Y

yg

I added rows to my resource table but the pivot table wasn't updated. Do i
need to rebuild the pivot table to include the added rows or is there a way
to update?
 
N

Nick Hodge

If your datasource is another Excel range then go to the pivot table wizard
press back and reselect the data to include the new rows.

You might also for future use like to name the range and use that. This way
you would only need to expand the range name.

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