Link cell to PDF

[D Willett]

Hi

Is it possible to link an excel cell to a PDF doc on my hard drive or network like a hyperlink?

Thanks

[HansV]

You can insert a hyperlink to the PDF file.
If you want the file name to depend on the value of another cell, you can use the HYPERLINK function in a formula:

x372.png

[D Willett]

Hi Hans

The cells already hold information, dates and stuff.
Is there another way or is it a pointless task?

[HansV]

If the cell already contains text, that will be the suggested text to display when you select Insert | Hyperlink. This text is independent of the target of the hyperlink:

x373.png

[D Willett]

Yes I see.
I may have to just deal with what I already have then.
FYI, the cell contains a date when a certificate expires which is visual and has condition formatting changing colour dependant on the current date and status ( as the previous post today ).
I was hoping to use the cell additionally to show the pdf certificate if clicked.

Thanks

[HansV]

That should be possible - just select Insert | Hyperlink...
Or is that not what you wanted?

[D Willett]

It's exactly what I wanted but I have Excel 2003, the hyperlink dialog won't let me navigate to a pdf doc !!
Or am I doing some thing wrong ?

Thanks

[HansV]

You should be able to hyperlink to any file, including .PDF files! Make sure that you have selected the appropriate item in the navigation pane on the left.

[D Willett]

Got it !! It's been a long day........ Thanks Hans !!