How to Fix Excel Hyperlinks Not Working After Converting to PDF
Question details
The user is experiencing an issue where hyperlinks that function correctly in an Excel workbook become unclickable after converting the file to a PDF.
- Product
- Excel / PDF
- Device & OS
- not provided
- Scenario
- Converting an Excel workbook containing hyperlinks into a PDF document.
- Observed behavior
- The hyperlinks are active and clickable in the original Excel file, but they are inactive and cannot be clicked in the resulting PDF file.
Ensure that the hyperlinks in your original Excel file are fully functional, pointing to the correct URLs or file paths, and formatted correctly before attempting the conversion again.
Verify PDF Export Settings to Preserve Links
Ensure that your export or save settings are configured to include document properties and hyperlinks during the PDF creation process.
When using the default 'Save As' feature in Excel, certain options might be disabled by default to reduce file size. Enabling document properties ensures that metadata, including hyperlinks, is transferred to the PDF.
Go to 'File' > 'Save As' and choose the destination folder for your PDF.
In the 'Save as type' dropdown menu, select 'PDF'.
Click the 'Options' button located below the dropdown menu in the Save As dialog box.
Ensure that the checkbox for 'Document properties' is checked, as this helps preserve active links, then click 'OK' and 'Save'.
Export to PDF Using an Alternative Office Suite
If Excel's native converter fails to preserve links, opening the file in another program like OpenOffice or WPS Office and exporting it can resolve the issue.
Verify and Recreate the Hyperlink Type
Some PDF converters struggle with formula-based links. Recreating them as standard inserted hyperlinks can help the converter recognize them.
Seamlessly Convert Excel to PDF with Active Hyperlinks in WPS Office
WPS Office provides a robust, built-in PDF converter that accurately preserves your spreadsheet's formatting, data, and hyperlinks without requiring complex settings or third-party add-ins.
- 1. Open your Workbook: Launch WPS Office and open your Excel spreadsheet containing the hyperlinks.
- 2. Export to PDF: Click on the 'Menu' button in the top left corner, hover over 'Export to PDF', and select it.
- 3. Configure and Save: In the export dialog, ensure your save path is correct and click 'Export to PDF'. Your links will remain fully clickable in the output file.
Frequently Asked Questions
Why do my Excel hyperlinks disappear when saved as PDF?
This usually happens because the PDF export settings in Excel are not configured to include document properties, or you used the 'Print to PDF' function, which flattens the document and removes interactive elements.
Does the HYPERLINK formula work when converting to PDF?
Sometimes, links generated by the =HYPERLINK() formula are not recognized by standard PDF converters. Converting them to standard inserted links (Right-click > Link) often resolves this issue.
Can I fix broken hyperlinks in an already converted PDF?
Yes, if you have a dedicated PDF editor like WPS PDF, you can manually add, edit, or fix hyperlinks directly within the PDF document without needing to reconvert the original Excel file.
Do internal workbook links work in PDF format?
Internal links (links pointing to other sheets within the same workbook) can be preserved in PDFs, but they are converted into PDF bookmarks or internal page destinations. Ensure your export settings are set to include bookmarks.
