Software

Ask something
Question Locked

Excel 2003 and hyperlink to PDF files

0 helpful
3 replies

by kim

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Excel 2003 spreadsheet and need to insert hyperlinks to PDF files, and then distribute this Excel doc. I have tried various measures with no success, such as:

Put all PDF files into a zip file, and send via e-mail along with Excel doc. Recipient has unzipped PDF files and saved to computer, as with Excel doc. When receipient clicks on hyperlink, message appears that file can't be found.

Save PDF files and Excel doc to disc. Same results.

H~E~L~P

3 replies

by thumbsup2

When you insert a hyperlink, the path to the file you're linking to is usually the full path to where the document is stored on YOUR computer. For example, if you link to a document in C:\Documents and Settings\\My Documents\Folder1\MyFile.pdf ... that path won't work on someone else's computer.

Have your recipient edit the hyperlink and point it to where they have stored the documents on their own computer.

by triathlete1981

and it's just a variation of the previous poster...

save all documents into a folder. The path is going to be your local machine. However, create another folder in the folder that stores the PDFs. Then make the path to the PDFs .\foldername\filename.PDF. The dot will be the parent folder whether it's on your computer or not.

This discussion is closed to new replies.