How to Fix Excel 2016 PDF Export Not Creating a File
Question details
Users are unable to successfully generate a PDF file when exporting a spreadsheet from Microsoft Excel 2016.
- Product
- Microsoft Excel 2016, Acrobat PDFMaker
- Device & OS
- Windows 10
- Scenario
- Attempting to export or save an Excel workbook as a PDF document using the Acrobat PDFMaker add-in or the built-in export function.
- Observed behavior
- The PDF export process appears to run and complete without displaying any error messages, but no PDF file is actually created or saved in the designated destination folder.
Verify that your Windows 10 account has full administrator privileges and that you are saving the file to a local directory with write permissions, such as your Desktop or Documents folder.
Enable and Repair the Acrobat PDFMaker Add-in
Use this solution if you rely on the Adobe Acrobat PDFMaker extension to generate your PDFs, as the Windows 10 upgrade can disable or break the add-in.
When moving from older operating systems to Windows 10, the Acrobat PDFMaker add-in for Office can become disabled or lose compatibility due to missing updates. Re-enabling the COM add-in and ensuring both Office and Acrobat are updated often resolves the silent failure.
Open Adobe Acrobat, navigate to Help > Check for Updates, and install any available updates. Do the same for Excel 2016 via File > Account > Update Options > Update Now.
Launch Excel 2016, click on 'File' in the top left corner, and select 'Options' at the bottom of the menu. In the Excel Options window, click on 'Add-ins' on the left sidebar.
At the bottom of the Add-ins window, change the 'Manage' dropdown to 'COM Add-ins' and click 'Go...'. Check the box next to 'Acrobat PDFMaker Office COM Addin' and click 'OK'.
Use Excel's Built-in PDF Export Feature
Bypass third-party add-in glitches by utilizing Microsoft Excel's native PDF creation tools.
Export to PDF Seamlessly with WPS Office
If Excel 2016 continues to struggle with PDF exports after your Windows 10 upgrade, consider switching to WPS Office. It provides a robust, built-in PDF converter that works instantly without the need for troubleshooting unreliable third-party add-ins.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing .xlsx or .xls file. No formatting will be lost.
- 2. Click Export to PDF: Navigate to the 'Menu' or the 'Tools' tab on the top ribbon and select the 'Export to PDF' button.
- 3. Save your document: Select your desired export options, choose a destination folder, and click 'Export'. Your PDF will be generated immediately.
Frequently Asked Questions
Why does Excel say it published the PDF but the file is missing?
This usually happens due to a silent failure in the Acrobat PDFMaker add-in or saving to a directory where Windows 10 restricts write access (like the root C: drive). Checking folder permissions and updating the add-in usually resolves this.
Do I need Adobe Acrobat installed to save Excel files as PDF?
No. Excel 2016 has a native feature to save or export files as PDFs. You can simply go to File > Save As and choose PDF from the format dropdown list without needing Adobe Acrobat installed.
How do I fix the Acrobat PDFMaker add-in missing from the Excel ribbon?
Go to File > Options > Add-ins in Excel. Select 'COM Add-ins' from the Manage drop-down and click Go. Check the box next to Acrobat PDFMaker and click OK to restore it to the ribbon.
