Fix Excel Hyperlink Opening Folder Instead of PDF File
Question details
Users clicking a hyperlink in an Excel spreadsheet intended to open a PDF file find that it opens the containing folder instead.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Clicking a PDF hyperlink within an Excel spreadsheet to view a referenced document.
- Observed behavior
- The hyperlink opens the Windows File Explorer folder path instead of launching the actual PDF document in the designated PDF reader.
Ensure the target PDF file has not been recently moved, renamed, or deleted from its original location on your computer.
Check and Correct the Hyperlink Path
Verify that the hyperlink explicitly targets the PDF file with its file extension, rather than just the directory path.
When creating a hyperlink, it is easy to accidentally select the folder containing the file instead of the file itself. Excel will attempt to open whatever path is specified in the Address bar.
Right-click the problematic hyperlink cell in Excel and select 'Edit Hyperlink' from the context menu.
Look at the 'Address' field at the bottom of the dialog box. Ensure the path ends with the exact PDF filename including the '.pdf' extension (e.g., 'C:\Documents\Report.pdf' instead of just 'C:\Documents\').
If the path is incorrect, browse through your folders within the dialog, explicitly click on the target PDF file, and click 'OK'.
Click the hyperlink cell again to confirm it now opens the actual PDF file.

Fix HYPERLINK Formula Syntax
If you are using the HYPERLINK function, ensure the file path is correctly formatted and enclosed in quotation marks.
Verify Default PDF Application Settings
Ensure your operating system is set to open PDF files with a dedicated PDF reader rather than an unassociated or incorrect program.
Easily Link and Open PDFs within WPS Spreadsheet
WPS Office offers a built-in Spreadsheet editor and PDF reader, eliminating compatibility issues when opening linked PDF files. You can manage your data and read linked PDFs seamlessly within a single tabbed interface.
- 1. Open your Spreadsheet: Launch WPS Office and open your Excel workbook.
- 2. Insert a Hyperlink: Right-click a cell, choose 'Hyperlink', and accurately select the target PDF file on your computer.
- 3. Open the PDF: Click the hyperlink cell to instantly open the PDF file in a new tab within the same WPS Office window.

Frequently Asked Questions
Why do hyperlinks with spaces in the file path fail to open the file?
If a file path contains spaces and is not properly formatted, the application might misinterpret the link and truncate it at the first space. This often results in the system opening the parent folder instead. To fix this, ensure the entire path is properly enclosed in quotation marks when using formulas, or re-select the file using the 'Edit Hyperlink' dialog.
Can a moved or renamed PDF file cause the hyperlink to open a folder?
Yes. If the PDF file was moved, renamed, or deleted but the parent folder remains, the hyperlink can no longer locate the specific file. As a fallback, Windows File Explorer will often open the last known valid directory in the path.
How do I link to a specific page in a PDF from Excel?
To link to a specific page, you can append '#page=[page number]' to the end of your hyperlink address (e.g., 'C:\document.pdf#page=4'). Note that this feature depends heavily on your default PDF reader supporting these parameters when launched from an external spreadsheet application.




