Thread: Pivot table
View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

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
HIS


"yg" wrote in message
...
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?