How to Make PDF Links Open in a New Window After Excel Conversion
Question details
The user wants to configure hyperlinks in a converted PDF so that clicking them opens linked documents in a separate window instead of replacing the current document.

- Product
- Device & OS
- not provided
- Scenario
- Clicking on inter-document hyperlinks within a PDF file that was recently converted from an Excel spreadsheet.
- Observed behavior
- Links currently open the target document within the same Acrobat window, forcing the user to navigate back to view the original PDF.
Ensure you have access to a dedicated PDF editor, as basic PDF readers do not allow you to modify advanced hyperlink properties or actions.
Modify Global Link Preferences in Acrobat
Change the application settings in your PDF viewer to force all cross-document links to open in a new window.
This method changes how your specific PDF viewer handles links. Keep in mind that this is an application-wide setting; it affects all PDFs opened on your computer, but it will not affect how the PDF behaves on other users' computers.
Launch Adobe Acrobat and go to 'Edit' > 'Preferences' (Windows) or 'Acrobat' > 'Preferences' (Mac).
Select the 'Documents' category from the left-hand menu pane.
Uncheck the option labeled 'Open cross-document links in same window' and click 'OK' to save the changes.
Edit Link Properties Using a PDF Tool
Use a standalone PDF link-editing tool or plug-in to modify the specific link actions inside the PDF.
Use WPS Office to Manage PDF Hyperlinks
WPS Office features an advanced built-in PDF editor that allows you to accurately convert Excel spreadsheets to PDF while preserving links, and easily customize hyperlink properties all in one lightweight application.
- 1. Open the PDF in WPS Office: Launch WPS Office and open your converted PDF document.
- 2. Access the Edit Menu: Navigate to the 'Edit' tab at the top of the screen.
- 3. Select the Link Tool: Click on 'Link' > 'Add/Edit Link' to highlight all active hyperlinks in the document.
- 4. Modify Link Destination: Double-click the target link to adjust its destination, appearance, and action behaviors.
- 5. Save Changes: Click 'Save' to apply the updated link settings to your PDF.

Frequently Asked Questions
Why did my Excel links stop working after saving as PDF?
If you use the 'Print to PDF' function, hyperlinks are flattened and lost. To retain active links, always use the 'Save As PDF' or 'Export to PDF' features within your spreadsheet software.
Will editing the PDF link properties affect other users opening the file?
Yes. If you change the link's action natively using a PDF editor (rather than changing your local app preferences), the instructions are saved within the document and will apply when other users open the file in a compatible PDF reader.
Can I set web URLs to open in a new tab by default?
Most modern PDF readers and web browsers automatically handle external 'http' or 'https' web URLs by opening them in a new tab or the default browser window. Cross-document (local file) links are the ones that typically require specific property adjustments.





