Skip navigation
JackiesGirl
JackiesGirl Calculating status...
Currently Being Moderated

Hyperlinks not retained when created using formulas in Excel 2007

May 11, 2012 12:32 PM

Categories: Windows Tags: #links #active #excel #hyperlinks #formulas #2007

I have an Excel spreadsheet with hyperlinks created using the =HYPERLINK( Link Location, Name) formula, or a very similar formula. I've tried a couple of different ones with the same result.

 

The hyperlinks work while in the Excel file. However, when the document is converted to PDF, the links are no longer active, but the cell does still contain the "friendly name." I imagine the problem is because Acrobat does not deal with the "hidden" behind-the-scenes-text, like a formula, and only deals with the text in the cell.

 

Is there a work-around for this so I can create my PDF report directly from my Excel file?

 

So far, the only work-around I have found is to copy/paste the needed cells into a Word document and PDF from there. While that works, it's not optimal. This is a document that is updated on a continual bases.

 

Thanks for any help or suggestions.

 

Nanette

342 Views   1 Reply   Latest reply: CtDave, May 11, 2012 2:20 PM
 
Replies
  • CtDave
    Currently Being Moderated
    1. CtDave,
    May 11, 2012 2:20 PM   in reply to JackiesGirl
    Report

    Excel forumula don't carry through into PDF.

    They have no meaning to PDF (see ISO 32000-1).

     

    Be well...

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points