Excel hyperlinks not working once file is converted to PDF

Good morning francescovba

... and welcome to the forum!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I have added them fopr you on this occasion, so no further action is necessary on your part, but please bear in mind for future.

Your issue is a common one. I suspect that your hyperlinks are built via a formula (=HYPERLINK)? If this is so, then your problem is right there. Replace them with a hard typed hyperlink and they should then carry across OK to .pdf format.

You could always try using an external .pdf generating utility (I use the free version of PrimoPDF) to see if that works - the conversion utility bundled with Excel seems to be riddled with oddities like this. The downside of this would then be that your macro will no longer work.

HTH

DominicB

Hello Dominic,

First of all, thank you for your reply. I would like to ask you what exactly you mean by "hard typed hyperlink"? do you mean typing them by hand in the excel file or inserting by hand in the PDF after its been created. If so we need everything to be created by macro as adding anything by hand unfortunately is not an option as our client expects it that way.

Thank you in advance for your help and cooperation.

Francesco

Hi francescovba

Create a hyperlink by this way :

Formula:

Please Login or Register  to view this content.

This will not translate into a hyperlink on a .pdf file. Whether your client expects it that way or not is irrelevant. It's an Excel (or a .pdf) limitation.

Create a hyperlink by selecting a cell, and navigating to Insert > Link > Insert link and typing a web URL into the Address box WILL translate into a link in a .pdf file.

The only way I can think of you getting around that is by using code to generate the hyperlinks. Without seeing what you have set up at the moment, I can't go further than that.

HTH

DominicB