Using Excel 2007 in Windows 10, but had the same problem in Vista. Have a workbook with about 50 sheets, half are data sheets, half are charts based on the data. To print only the charts, I hide all data sheets, right-click on a chart sheet and select all sheets. In print preview, I see 68 pages, & can scroll through all 68. But when I click print, either to a printer or to PDF, instead of printing or saving all in one 68-page batch, they print or save in smaller batches of varying page counts. To get one PDF file of all 68 pages, I have to save several times and then merge the files. Any ideas why, and what I can do?