'%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 Excel Creating a Blank PDF During Export
Question details
The user is experiencing an issue where exporting a spreadsheet to a PDF file results in a completely blank document instead of displaying the data.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or saving an existing Excel workbook as a PDF file.
- Observed behavior
- The generated PDF file is entirely blank and does not contain any of the spreadsheet's content.
Before proceeding with installation repairs or Safe Mode testing, ensure you have saved a backup copy of your current workbook and closed all running Microsoft Office applications.
Repair the Microsoft Office Installation
Use this solution if the blank PDF issue is caused by corrupted or damaged Microsoft Office program files.
A damaged Office installation can interfere with built-in export features like the PDF converter. Running an Online Repair will scan and replace any corrupted files within the Microsoft Office suite.
Click the Windows Start menu, type 'Control Panel', and press Enter.
Click on 'Programs', then select 'Programs and Features' to view your installed applications.
Scroll through the list to find 'Microsoft Office'. Right-click it and select 'Change'.
In the pop-up window, select 'Online Repair' and click the 'Repair' button. Wait for the process to complete, then restart your computer and test the PDF export in Excel again.
Start Excel in Safe Mode
Running Excel in Safe Mode disables external add-ins, helping you identify if a third-party plugin is causing the blank PDF issue.
Test with a New Workbook
Determine whether the issue is isolated to a specific corrupted spreadsheet or a broader application problem.
Export Spreadsheets to PDF Flawlessly with WPS Office
If Microsoft Excel continues to fail when exporting PDFs due to installation errors or add-in conflicts, consider switching to WPS Office. It is a robust, free alternative that handles complex spreadsheet formatting and native PDF conversion seamlessly without requiring constant troubleshooting.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx file. The formatting will remain exactly the same.
- 3. Export to PDF: Click the 'Menu' button in the top-left corner, select 'Export to PDF', review your layout options, and click 'Save'.
Frequently Asked Questions
Why does my Excel to PDF export cut off my data?
This is typically caused by incorrectly configured Page Setup settings or an improper Print Area. Before exporting, go to the Page Layout tab, click 'Print Area', and select 'Clear Print Area', or adjust the scaling options to fit your data on one page.
Can hidden rows or columns cause a blank PDF export?
Yes. If the specific range you selected to export only contains hidden rows or columns, the resulting PDF document will be blank. Ensure that the cells you are trying to export are visible.
How do I export an entire Excel workbook to a single PDF?
When you are in the Save As dialog box for a PDF, click the 'Options...' button. Under the 'Publish what' section, select 'Entire workbook' instead of 'Active sheet(s)', then click OK and save.
Why is the font displaying incorrectly in the exported PDF?
This can happen if the original font used in the spreadsheet is not fully supported by the PDF generation engine or if it fails to embed properly. Try changing the font in Excel to a standard system font like Arial or Calibri before exporting.
