How to Make Excel PDFs Open Automatically After Publishing
Question details
The user needs Excel to automatically launch the resulting PDF file immediately after saving or exporting a spreadsheet as a PDF.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Saving or publishing an Excel workbook as a PDF document.
- Observed behavior
- Excel successfully creates the PDF but does not open it automatically for viewing, even when a capable PDF reader like Adobe Acrobat is installed.
Ensure you have a default PDF viewer, such as WPS PDF or Adobe Acrobat, installed and set as your system's default application for opening PDF files.
Enable the "Open file after publishing" setting in the Save As Dialog
You can resolve this issue by checking a specific option during the PDF export process in Excel, which commands the system to launch the default PDF viewer immediately.
By default, Excel might just save the file in the background without launching it. Adjusting the publish settings ensures you can instantly review the generated PDF.
Navigate to the "File" tab in the top ribbon, select "Save As", and choose your desired folder or saving location.
In the Save As dialog window, click on the "Save as type" dropdown menu and select "PDF (*.pdf)".
Look for the checkbox labeled "Open file after publishing" located right below the file format selection. Click to ensure it is checked.
Click the "Save" button. Excel will generate the PDF document and immediately open it in your default PDF application for viewing.

Convert and Open PDFs Instantly with WPS Office
WPS Office provides an integrated Spreadsheet and PDF solution, allowing you to seamlessly export your sheets to PDF and automatically preview them without switching between heavy applications.
- 1. Open your spreadsheet in WPS Office: Launch WPS Office and open your existing Excel workbook.
- 2. Export to PDF: Go to the "Menu" or "Tools" tab and click on "Export to PDF".
- 3. Configure export settings: In the export dialog, ensure the option to open the file automatically after exporting is enabled.
- 4. Complete the export: Click "Export". WPS PDF will instantly open the newly created file for your review within the same application window.

Frequently Asked Questions
Why is the "Open file after publishing" checkbox missing or grayed out in Excel?
This usually happens if your operating system does not have a default PDF viewer installed or configured. Installing a PDF reader like WPS PDF or Adobe Acrobat and setting it as the default should make this option available.
Will checking this setting apply to all future PDFs I save in Excel?
Yes, once you check the "Open file after publishing" box, Excel generally remembers this preference for future PDF exports during your current session and across future sessions.
Can I make the PDF open in a specific program rather than the default viewer?
Excel relies on your operating system's default file associations to open the published PDF. To change which program it opens in, you must change your default PDF app settings directly within your Windows or Mac system settings.




