PDF Opening Issues

How to Make Excel PDFs Open Automatically After Publishing

Elise WilliamsElise Williams Nov 2, 2026 869 views

Question details

The user needs Excel to automatically launch the resulting PDF file immediately after saving or exporting a spreadsheet as a PDF.

How to Automatically Open PDFs After Publishing in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the Save As dialog

Navigate to the "File" tab in the top ribbon, select "Save As", and choose your desired folder or saving location.

2
Select the PDF file format

In the Save As dialog window, click on the "Save as type" dropdown menu and select "PDF (*.pdf)".

3
Check the open option

Look for the checkbox labeled "Open file after publishing" located right below the file format selection. Click to ensure it is checked.

4
Save and publish

Click the "Save" button. Excel will generate the PDF document and immediately open it in your default PDF application for viewing.

Enable the "Open file after publishing" setting in the Save As Dialog
Persistent Setting: Excel typically remembers this preference, so future PDF exports will automatically open without needing to check the box every time.
Seamless PDF Creation

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. 1. Open your spreadsheet in WPS Office: Launch WPS Office and open your existing Excel workbook.
  2. 2. Export to PDF: Go to the "Menu" or "Tools" tab and click on "Export to PDF".
  3. 3. Configure export settings: In the export dialog, ensure the option to open the file automatically after exporting is enabled.
  4. 4. Complete the export: Click "Export". WPS PDF will instantly open the newly created file for your review within the same application window.
Fully compatible with Microsoft Excel (.xlsx) formatsBuilt-in PDF reader to instantly view exported filesLightweight and fast, saving your system resourcesFree to use for everyday office and document tasks
microsoft office alternative - wps office

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.