'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix an Excel Workbook That Will Not Save as PDF
Question details
The user is trying to export or save a macro-enabled Excel workbook as a PDF, but receives an error stating the document was not saved.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or saving a macro-enabled spreadsheet to a PDF format.
- Observed behavior
- Excel displays an error message reporting that the document was not saved, preventing the PDF from being generated.
Ensure that your workbook is not restricted by permissions or passwords, and verify that no other programs are currently locking your destination folder.
Clear the PDF/A Compliant Setting
Disabling the PDF/A compliance option often resolves export errors in macro-enabled workbooks.
PDF/A is a standardized format designed for long-term archiving. Sometimes, strict compliance settings can conflict with certain elements in macro-enabled workbooks, causing the save process to fail.
Go to File > Export > Create PDF/XPS Document, or choose Save As and select PDF from the format dropdown. Then, click the 'Options...' button.
In the Options dialog box, locate the 'PDF/A compliant' checkbox under the PDF options section and uncheck it.
Click 'OK' to close the dialog, and then click 'Publish' or 'Save' to export your workbook as a PDF.
Disable Third-Party Excel Add-ins
Conflicting COM add-ins can sometimes block Excel's native file conversion processes.
Use the Microsoft Print to PDF Feature
A quick workaround to generate a PDF when the native Export or Save As functions continuously fail.
Export Excel Workbooks to PDF Seamlessly with WPS Office
If Microsoft Excel continues to fail when saving your workbooks as PDFs, try WPS Office. It is a highly compatible, free alternative that effortlessly opens macro-enabled files and exports them to PDF without errors.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
- 2. Open Your Workbook: Launch WPS Spreadsheet and easily open your macro-enabled Excel workbook.
- 3. Export to PDF: Click 'Menu', select 'Export to PDF', and save your document instantly without encountering export errors.
Frequently Asked Questions
Why does Excel fail to save my macro-enabled workbook as a PDF?
This commonly happens due to strict PDF/A compliance settings in the export options, corrupted worksheet data, or third-party COM add-ins interfering with Excel's native PDF converter.
What is the difference between Export to PDF and Print to PDF?
'Export to PDF' uses Excel's built-in converter which preserves formatting, hyperlinks, and bookmarks. 'Print to PDF' acts as a virtual printer, creating a visual flat document which is an excellent workaround when standard export fails.
How can I tell if my Excel workbook is corrupted?
If a specific workbook fails to save as a PDF but a blank, newly created workbook exports successfully, your original file may have corrupted data. You can often resolve this by manually copying your worksheet content into a fresh workbook.
Can I repair Microsoft 365 to fix PDF saving issues?
Yes. If clearing the PDF/A option and disabling add-ins does not work, go to your Windows Control Panel, select Programs and Features, right-click Microsoft 365, and choose 'Change' to run an Online Repair.
