Fix Excel Text Box Hyperlinks Losing URL Anchors in PDF Export
Question details
The user needs an Excel text box hyperlink to retain its URL anchor when the workbook is exported to PDF.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A text box links to a web page with a fragment identifier, such as adresse.htm#textnotinclude, and the workbook is exported to PDF.
- Observed behavior
- The exported PDF may omit the fragment identifier from the text box link, while the same link in a worksheet cell works.
Open the workbook and test the full URL, including the # fragment, in a browser and in Excel. If the link uses a relative address, confirm that the destination will be accessible from the exported PDF.
Move the hyperlink to a worksheet cell before exporting
Use a cell hyperlink when the text box link loses its anchor in the exported PDF.
In Excel, select a worksheet cell where the clickable text can appear and enter a descriptive label.
With the cell selected, choose Insert > Link and enter the complete destination in the Address field, including the # fragment.
Choose File > Export or File > Save As and select PDF. Open the PDF and click the cell link to confirm that it reaches the intended section.

Edit the PDF link annotation in Adobe Acrobat
Use Acrobat to add or correct the link when the PDF must retain the text box as the clickable object.
Update Excel and Acrobat and retest the export
Check for available updates before repeating the export if the link behavior may be version-dependent.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move existing workbooks into WPS. Test exported PDF hyperlinks before sharing, as link behavior may differ between applications.

Frequently Asked Questions
Why does the PDF link open the page but not the intended section?
The PDF link annotation may have lost the fragment after the # character during export. Edit the link in Acrobat and enter the complete URL, including the fragment.
How do I add a hyperlink to an Excel cell?
Select the cell, choose Insert > Link, and enter the full destination in the Address field. Export to PDF and test the link.
Can I keep the text box clickable in the PDF?
Yes. In Acrobat, use Edit PDF > Link > Add/Edit Web or Document Link to edit the existing annotation or create a link area over the text box, then enter the full URL.
Will an internal Excel link replace a web page anchor?
No. An internal link points to a location in the workbook, while a URL fragment identifies a section of an external page. Use the full web address and fragment when the destination is a web page.




