You may want to look at defining a dynamic range name to your table.

Then use that range in your pivottable.

Debra Dalgleish has some nice notes at:
http://www.contextures.com/xlNames01.html#Dynamic

yg wrote:

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?

--

Dave Peterson