If you base your Pivot Table on a Dynamic Range Name, the range will
automatically expand and contract to accommodate the data.

See this website for instructions:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"ED" wrote:

I am trying to "Refresh the Data" for my Pivot Table.

My data is a lot longer then it used to be. How do I make sure that all
numbers are included in the pivot table.

Right now the last three rows are cut off.

Thanks.
E