Web links disappear when PDF created from Excel Spreadsheet
Results 1 to 5 of 5

Thread: Web links disappear when PDF created from Excel Spreadsheet
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Web links disappear when PDF created from Excel Spreadsheet

    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?

  2. #2
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,588
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    13 Thread(s)

    Default Re: Web links disappear when PDF created from Excel Spreadsheet

    They are preserved for me printing via Acrobat.

  3. #3
    New Member
    Join Date
    Jun 2019
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Web links disappear when PDF created from Excel Spreadsheet

    Quote Originally Posted by shg View Post
    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?

  4. #4
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,588
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    13 Thread(s)

    Default Re: Web links disappear when PDF created from Excel Spreadsheet

    They don't work using Print as PDF for me either. They do using Acrobat with the option ticked to Add Links.

  5. #5
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,588
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    13 Thread(s)

    Default Re: Web links disappear when PDF created from Excel Spreadsheet

    Ah -- they don't work using Acrobat either when I use the Friendly_name argument.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •