OmniDocHow to keep hyperlinks clickable after converting Excel to PDF
If the hyperlink does not click after exporting the PDF, it is probably a problem with the link type or export settings. This article explains how to handle URLs, file paths, and jumps within worksheets, and provides export steps and item-by-item verification methods.
Key points of this article
- External URLs are usually easier to retain. Links to local files or locations within this table must be processed before exporting.
- Before exporting, click on the links one by one and classify them, and record the three categories of URL, file and internal jump, so that the subsequent processing method can be based on it.
- After exporting, use a PDF reader to click on each link one by one to test. Don’t just check whether the link text is displayed, the jump target is the key.
- Jumping across worksheets may not be effective in PDF. You can change it to a table of contents page or add page number instructions in the PDF.
Many people have completed an Excel spreadsheet with a catalog, quotation or data summary. There are links to other worksheets in the spreadsheet, as well as links to web pages or files. After converting it to PDF and sending it to others, the link won't click or jumps to the wrong location, so you can only fix it manually. This article is for anyone who needs to give a linked form to someone else to read, file, or print.
After reading this article, you can determine which links will be retained, which ones need to be adjusted in advance, and know how to check them one by one after exporting. The article talks about general practices. The performance of different office software versions may be different. For important links, please refer to your own test results.
How to keep links when converting Excel to PDF? One sentence conclusion
Direct answer: External URLs are generally easier to retain; links pointing to internal cells or worksheets in the same workbook are prone to problems and need to be adjusted before exporting.
| your situation | Recommended practices | reason |
|---|---|---|
| Link points to a web page (starting with http or https) | Export PDF directly and click test in PDF reader after exporting | A URL is an external address and is usually still a clickable link area after exporting |
| Links point to other files or folders on this machine | Place the target in a fixed location and test it before exporting; change it to the URL when sending it to others, or indicate the file name in the text. | The local path may not exist on the other party's computer |
| Links to other worksheets or cells within this table | Change to table of contents page and description text before exporting, or correspond to page numbers in PDF | Jumping across worksheets may not take effect in PDF, and the results are affected by the export settings. |
| Links are generated by formulas (such as the HYPERLINK function) | Confirm that the formula result is readable text, and test each item individually after exporting | The formula results are output in text form, and clickability needs to be actually checked. |
| The table is large and only part of the content is needed | Set the print area first, export only the required parts, and then test the link. | The smaller the range, the faster the verification |
Before you start: Confirm these points first
1. Type of link. Click or view the target addresses of the links one by one, and divide them into three categories: URL, file path, and internal location. The type determines what processing method will be used later. Without classification, it is difficult to judge which ones will fail.
2. Purpose of PDF. If the file is only for printing, it does not matter whether the links are clickable, but the link text and URL must be fully readable; if the file is to be viewed on a screen, make sure that each link can be clicked and jumps to the correct location.
3. Table format. Merged cells, hidden rows and columns, and page break positions will all affect PDF layout. When the layout changes, the location of the link will also move, and sometimes it will be cut off by pagination.
4. Software version and reader. Different versions of office software, as well as different PDF readers, may display and click links differently. It is recommended to export with the same version and test it in at least one reader.
5. Sensitive information. The link may contain intranet address, personal file path or account information. Check it before exporting to avoid sending it along with the PDF.
Steps to export PDF with clickable links in Excel
- Back up the original file. Save a copy before proceeding to avoid accidentally changing the links in the source table.
- Check the links one by one. Click each link and note whether it leads to a web page, a file, or a worksheet location. Try to make a simple list.
- Handle internal jumps. Change links to other locations in this table to content pages or explanatory text; if they cannot be retained, delete them directly before exporting, and write the corresponding page number or worksheet name in the text.
- Set the printing area and pages. Select the cell range to be exported, adjust the paper orientation and scaling, and ensure that the link text is not cut off.
- Select Export to PDF. Select the export or save as PDF function in Excel, select PDF as the file format, and save to a fixed location.
- View export options. If there are options related to quality, document structure, or published content in the export dialog box, make a note of your choices so that you can reproduce and check them later.
- Tested in PDF reader. Open the exported file, click the links one by one, and observe whether it jumps to the correct URL or page.
- Remediate broken links. For internal jumps that are still invalid, you can add page number descriptions in the PDF, or replace them with bookmarks, and re-export them.
If the original file is Excel that needs to be translated into another language, you can first upload the file on omnidoc.top, select bilingual comparison or translation only, download the translation, and then follow the steps above to export the PDF. The translation will change the text in the cell, the links must be re-checked after translation, and the results of machine translation must also be checked for important content.
Check each item after completion
| Check item | What do you think? | What if there's a problem? |
|---|---|---|
| Can the link be clicked? | Click each link in the PDF reader to see if the mouse has changed into a hand and if there is a reaction | If you can't click, first go back to the form to check the link type; the external address can be changed to the URL text written directly. |
| Is the jump target correct? | Click to confirm whether to reach the corresponding URL or page | If the target is wrong, go back to Excel to check the address. The common problem is to copy and paste with extra spaces or characters. |
| Whether the link text is complete | Check to see if it has been truncated or changed against Excel. | Re-export after adjusting column width or cell wrapping |
| Page number and typesetting | Flip through the pages to make sure that the form is not disassembled and the link does not go to another page | Re-export after adjusting the paging position or scaling |
| Sensitive information | Look up the intranet address, local path and so on in PDF | Delete or replace and re-export, and then send it to the other party |
When checking, it is recommended to click on each of the two different PDF readers. If you can click in only one reader, there are likely to be problems after sending it to others.
# Core comparison
| Practice | An appropriate situation | Main risk |
|---|---|---|
| Export directly, keeping all links | Links are all external URLs. | Internal jumps may fail and need to be tested one by one |
| Change the internal jump to the catalog page | There are a lot of cross-table jumps in the table. | The table of contents page needs to be maintained manually and updated synchronously after the table structure changes. |
| Change the link to a plain text address | Only need to print or archive, do not require click | Readers have to copy the address manually before they can access it |
# frequently asked questions (FAQ)
1. What if the link becomes plain text after Excel is converted to PDF?
It may be that the source cell is originally just text, looks like a link, and there is no real hyperlink. Go back to the table to see if the link is valid; if the link itself is valid, test it again on export.
2. Can the scanned version of PDF keep the link?
The scanned piece is a picture and there is no clickable link structure. If you only need to recognize the text before processing, you can use the OCR function on the OmniDoc desktop, but the recognition results should be checked item by item, and the link needs to be confirmed separately.
3. Will hyperlinks be retained when exporting back to Excel from PDF?
The OmniDoc desktop can export PDF to Excel, but whether the link is retained or not cannot be retained by default. Open the exported form and click OK one by one before using it.
4. Why do links to the same file behave differently on different computers?
Local paths, network permissions, PDF readers, and office software versions all affect the results. Try to test it completely on another device before sending it to others.
5. There is no office software, can you convert the linked form?
You can use online conversion sites or other general office tools, but pay attention to file size restrictions, watermarks, privacy policies, and whether links and typesetting are retained after export. Either way, click on it one by one according to the steps in this article.
# Summary
The key to how to keep the link from Excel to PDF is to distinguish the type of link first: the external URL is relatively stable, while the local path and internal jump need to be dealt with in advance. Click one by one with a PDF reader after export, which is more reliable than just looking at the link text. Do these two steps solidly so that the PDF sent out can be used normally.
