If those files that you're hyperlinking to exist on the individual pc's, I
_THINK_ you'll have to do some folder sharing. And then you could use those
shared folders on the other pcs.

You may want to ask in a forum dedicated to windows (include your version in
your question).

But it may be easier to find a network drive (are you on a network???) and
create a share that all of the pc's can access. Then you can use the UNC path
or even map the share and use a drive letter in the =hyperlink() formula:

=hyperlink("\\share\path\filename.xls","Click me")
or
=hyperlink("m:\filename.xls","click me")



Davva wrote:
<<snipped
Hi

I've tried to use the =hyperlink function in excel 2002 but I'm not
sure how the pathname should be written.

We have two computers on a network, imaginatively named PC1 & PC3 (PC2
was retired sometime ago). An excel file sites on PC1, as do the
documents we want to link to. We need to be able to open the excel
file and the links from PC3. Both relative file paths and setting the
file root in excel have not worked. I saw that the =hyperlink function
was suggested as a solution to similar problems and thought I'd give
it a shot.

I have tried a variety of pathnames in the =hyperlink function but
always receive the error "Cannot open the specified path".

I searched the web but couldn't find anything that described how to
write the file path correctly in excel. Can anyone tell me the correct
syntax?

Cheers

David

--

Dave Peterson