Fix Excel Freezing When Printing an Entire Workbook to PDF
Question details
The user needs to print a 17-worksheet Excel workbook to PDF without Excel becoming unresponsive.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Printing an entire workbook to PDF and checking whether Excel limits the number of worksheets included.
- Observed behavior
- Excel becomes unresponsive during PDF printing, and only the first six worksheets can be saved successfully.
In Excel, select File > Account and note the Office version under Product Information. Check which PDF printer or export method you used and whether a different workbook prints to PDF successfully.
Test the worksheets and export the workbook in smaller groups
Use this workaround to identify a problematic sheet and create PDFs without processing all 17 worksheets at once.
Excel does not have a simple worksheet-count limit for PDF export. Workbook complexity, page setup, or a particular worksheet may contribute to the freeze.
Open another workbook in Excel, select File > Print, choose your PDF printer, and try printing the entire workbook. If it works, focus troubleshooting on the original workbook.
In the original workbook, select the first sheet that did not save, then use File > Print to preview and print that sheet by itself. If it causes a problem, inspect its Page Layout settings, including Print Area, scaling, and page size.
Select a sheet tab, then hold Shift and select the last adjacent tab in a small group. Go to File > Print, choose Print Active Sheets and your PDF printer, and save the output with a distinct name.
Right-click a selected sheet tab and choose Ungroup Sheets, then repeat the process for the remaining groups. Use a PDF merge tool to combine the saved files in worksheet order.

Export the entire workbook directly from Excel
Try Excel's PDF export instead of printing through a PDF printer.
Export Excel Workbook Sheets to PDF with WPS Office
Open the workbook in WPS Spreadsheet and use its PDF export options to create a PDF from the available worksheets. If the full workbook is difficult to export, try smaller sheet selections.
- 1. Open the workbook: Open WPS Spreadsheet and select Open to choose the Excel workbook.
- 2. Start PDF export: Select Menu > Export to PDF. The command location may vary by WPS Office version.
- 3. Choose the sheets: In the export dialog, select the entire workbook or the worksheets you want to include, and review the available export settings.
- 4. Save the PDF: Choose a destination and select Export to PDF. If necessary, repeat with smaller groups of sheets.

Frequently Asked Questions
Does Excel limit a PDF export to six worksheets?
No. Excel does not impose a simple six-sheet limit on PDF export. A freeze may be related to workbook complexity, page setup, a worksheet, or the PDF printing process.
How can I tell whether one worksheet is causing the freeze?
Select the first sheet that did not save and use File > Print to preview and print it alone. If it fails, inspect its Page Layout settings, including its print area and scaling.
Where can I find my Office version?
In Excel, select File > Account and look under Product Information. Remove personal details before sharing a screenshot of that page.
How do I export the whole workbook without using a PDF printer?
Select File > Export > Create PDF/XPS Document > Create PDF/XPS. In Options, choose Entire workbook, then publish the file.
Can I combine PDFs exported from separate groups of worksheets?
Yes. Save each group with a distinct file name, then use a PDF merge tool to combine the files in the same order as the workbook sheets.




