Ed,

right click in the pivot table, choose pivot table wizard, then back, then
select the required range with your mouse

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

--
Message posted via http://www.officekb.com