Printing Problems

Fix Excel Freezing When Printing an Entire Workbook to PDF

Olivia MillerOlivia Miller Nov 20, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Test a different workbook

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.

2
Check the next worksheet

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.

3
Print a group of sheets

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.

4
Repeat and combine

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.

Test the worksheets and export the workbook in smaller groups
Ungroup sheets after printing: While worksheets are grouped, edits can affect multiple sheets. Right-click a sheet tab and select Ungroup Sheets before making changes.
Export with WPS Office

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. 1. Open the workbook: Open WPS Spreadsheet and select Open to choose the Excel workbook.
  2. 2. Start PDF export: Select Menu > Export to PDF. The command location may vary by WPS Office version.
  3. 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. 4. Save the PDF: Choose a destination and select Export to PDF. If necessary, repeat with smaller groups of sheets.
Export workbook sheets to PDF from WPS SpreadsheetOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interfaceWork with spreadsheets using the free WPS Office suite
microsoft office alternative - wps office

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.