Print Preview missing pages - Pivot table

[Mar72vin]

Using Excel 2007 (unsure if this is a problem with previous versions) when i
set a large pivot table (1000+ rows) to "Insert Page Break After Each Item"
the last few excel pages are not printed.

These pages do not show up in the print preview either.

If I remove the "Insert page break" option all items are printed correctly.

Any ideas on how to fix this?

 

[Mar72vin]

I have taken this problem to microsoft. It appears that there is a problem
with the "Fit-to" option in page setup.

I had originally set the "fit to" option to 1 page wide by 1000 tall.

Even though i only had 22 pages, the fit to scale was losing a few pages at
the end of the document.

The method that works in my case is to use the fit to option "1 page wide"
but leave the "by pages tall" option blank.