Fix Excel for Mac Printing Problems in a Large Macro-Enabled Workbook
Question details
Identify why a large macro-enabled workbook prints inconsistently in Excel for Mac.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user needs to print a large, frequently updated workbook containing many interconnected worksheets and macros.
- Observed behavior
- The workbook does not print consistently, although other workbooks print normally.
Identify which worksheets and printer were involved in failed print attempts. Locate an older version of the workbook and make a separate test copy before changing print settings or testing macros.
Isolate the Affected Worksheets and Print Areas
Use this approach to determine whether a particular sheet or print setting triggers the problem.
Open the test copy in Excel, select one worksheet tab, and choose File > Print. Under the print options, select the active sheet and try printing it.
Select and print the remaining worksheet tabs individually, noting any sheet that fails or produces unexpected output.
On an affected sheet, open Page Layout > Print Area and clear the existing print area. Select the cells you need, set a new print area, and try File > Print again.
Choose File > Print for the affected sheet, then use the PDF menu in the macOS print dialog to save it as a PDF. Open the PDF and check whether the expected pages appear.
Compare an Older Workbook and Test Macros
Use an older version and a separate test copy to check whether a recent change or macro is involved.
Test Another Printer and Update Excel and macOS
Use this if the issue remains unresolved or PDF output is correct but physical printing fails.
Review and Print Spreadsheets with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility to help you move between office suites. It does not repair Excel for Mac printing issues; test important workbook features and output before relying on it for a macro-enabled file.

Frequently Asked Questions
How can I tell which worksheet is causing the printing problem?
Select each worksheet tab in turn and choose File > Print with the active-sheet option. Record which sheets fail, then inspect their print areas and page settings.
Why should I try printing the workbook to PDF?
Choose File > Print and use the PDF menu in the macOS print dialog. If the PDF is correct but a physical print fails, the printer or its configuration may be involved.
Can a macro cause an Excel workbook to print incorrectly?
A macro that changes print settings or controls printing could contribute. Reopen a test copy without enabling macros, then print the same sheet to compare results.
What does it mean if an older version prints normally?
A change made after that version was saved, or corruption in the newer file, may be involved. Compare the affected sheets, print areas, and macros in the two versions.
Can WPS Office fix the Excel for Mac printing issue?
No. WPS Office is an alternative spreadsheet suite, not a repair for Excel. It can open XLSM files, but test macros, workbook behavior, and printed output before using it for this workbook.




