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?
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
They are preserved for me printing via Acrobat.
 
Upvote 0
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?
 
Upvote 0
They don't work using Print as PDF for me either. They do using Acrobat with the option ticked to Add Links.
 
Upvote 0
Ah -- they don't work using Acrobat either when I use the Friendly_name argument.
 
Upvote 0

Forum statistics

Threads
1,223,575
Messages
6,173,148
Members
452,502
Latest member
PQCurious

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top