Skip to main content
Participant
February 19, 2021
Answered

Changing links to open in new window after converting from Excel

  • February 19, 2021
  • 1 reply
  • 838 views

Hello,

 

I'm creating a large list of hyperlinks to documents within an Excel file. When I convert the spreadsheet to pdf, the links continue to work but open the linked documents in the current Adobe window and close the orginal document. I know I can change my Adobe document preferences to allow cross-document links to open in another page, but that must be done by each indiviual user of my document. I understand when creating links directly in Adobe, you can select the open in new window option.

 

Is it possible to edit the links I have already created post Excel conversion to also have the open in new window option? 

This topic has been closed for replies.
Correct answer try67

There are two ways of doing it. You can change the links themselves, or the app setting.

The latter can be done by embedding a simple script in your file, but note that it will change this setting at the app-level, so for all the documents the user opens, not only yours, so it might be a good idea to ask their permission (or at least notify them) first.

The former requires using a plugin or stand-alone tool, like this (paid-for) one I've developed:

https://www.try67.com/tool/convert-all-links-in-a-pdf-to-open-in-new-window

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
February 19, 2021

There are two ways of doing it. You can change the links themselves, or the app setting.

The latter can be done by embedding a simple script in your file, but note that it will change this setting at the app-level, so for all the documents the user opens, not only yours, so it might be a good idea to ask their permission (or at least notify them) first.

The former requires using a plugin or stand-alone tool, like this (paid-for) one I've developed:

https://www.try67.com/tool/convert-all-links-in-a-pdf-to-open-in-new-window

Participant
February 22, 2021

Thank you! The tool works perfectly. Now I don't have to ask users to change their preferences or manually change all the links within the pdf. Definetely a time saver.  

try67
Community Expert
Community Expert
February 22, 2021

Glad to hear it!