Creating a hyperlink to a word doc

[clemkonan]

I am completing a project summmaryand need to create a hyperlink to a word document. The excel sheet , PDF files and Word files I will be using are all in one folder called clemdata which is on my network G:/ drive.

I want to add the hyperlinks as short cuts to the document so that as the reader reviews the excel summary sheet he/ she can view the document of interest with ease.

For my external clients I have the same data on a CD and would like to issue copies that would work in a similar fashion.

My problem is that when I create the link Excel returns the message “cannot open the specified file" albeit I can see the path and it looks ok

I am using Windows XP and Excel 2003. Funny this is in an adjacent cell I have a hyperlink to a Word doc on my H: drive and it is working fine. What gives?

 

[clemkonan]

Interstingly enough the difference appears to be file type. The cell with the Word Doc hyperlink works fine and I can successfully create addtional links in the same column.

In the adjacent column where I am having problems the link works if it is a Word document the problem is for the example I am reporting it is a PDF file. Does this mean I cannot hyperlink a PDF doc?

 

[MDOTJR]

you are supose to hyperlink to anything ... i was not too clear on the matter..the only problem is the source try putting everything in one folder and linkig it first... if they work from a particular source it can be a security issue

 

[gwkenny]

.

I'll hazard a guess that maybe the file type PDF is not defined as Acrobat files, so when Excel sees you opening that via a hyperlink, it tries to open it in Excel. Course Excel get's confused and thus you get your error.

Can't be a security issue because the OP said everything was in the same directory.

To check if the PDF file type is correctly defined, open Windows Explorer. Choose the menu Tools/Folder Options. Then click the File Types tab. Make sure PDF files are defined as Adobe Acrobat files.

If PDF is not there, click New. Type in PDF, and choose advanced, and select Adobe Acrobat File. If Acrobat is not there, then you'll have to install it on your machine (which should automatically define the PDF file type).

Just a guess. Probably wrong.