Web links disappear when PDF created from Excel Spreadsheet

VUProf

New Member
Joined
Jun 11, 2019
Messages
9
I have built a report in Excel. The report includes a set of web links. I used the following formula to create a link and the link works perfectly in Excel. However, when I convert the Excel report to PDF, the link doesn't work. Any suggestions?

=IF(OR(O204="Blind Spot", I204<4), HYPERLINK("website url", "Dev Link"),"")

I've not had this problem when I've embedded links in a Word doc and then converted to PDF. Any suggestions on how to keep those active?
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
They are preserved for me printing via Acrobat.
 

VUProf

New Member
Joined
Jun 11, 2019
Messages
9
They are preserved for me printing via Acrobat.
Mine don't, even when I do a "Print as PDF."

I wonder if it is because the link is based upon a conditional statement and has a "label" rather than the full URL?
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
They don't work using Print as PDF for me either. They do using Acrobat with the option ticked to Add Links.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
Ah -- they don't work using Acrobat either when I use the Friendly_name argument.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,018
Messages
5,466,063
Members
406,462
Latest member
I10V3xl

This Week's Hot Topics

Top