print area Excel 2007
 

I have a pivot table in a worksheet that is updated each month. When I
update the pivot table and try to drag over the print area to cover the new
data, Excel converts the entire pivot table into individual pages. So
instead of 3 pages to print, I get 300 pages to print with 1 cell on each
page. Please Help....