Hyperlink problem

[mark]

I've got two workbooks on a shared drive with hyperlinks
linking the two. When a user clicks on the hyperlink on
the first workbook, it takes him to the second workbook.
Fine. However, when the user clicks on the hyperlink in
the second workbook to go back to the first, the error
message says that that workbook is already open and it
cannot open two files with the same name. Help is
appreciated!

 

[Dave Peterson]

I just tried a small test in xl2002 and it worked ok for me. I use
Insert|Hyperlink to create the links.

Are you sure that the hyperlinks point at the file you want--same folder and
everything.

You may want to give the version of excel and how you created the links
(insert|hyperlink or =hyperlink()). (they both worked ok for me.)

 

[David McRitchie]

Although I would normally use the Back button Alt+LeftArror
I tested with hyperlink worksheet function to out and to come back
and got the same error as Mark. The problem was an incorrect sheetname
in the second link. Not that you could see that there was no sheet4
in the first workbook and it should be sheet3 for the return as below..

=HYPERLINK("[xenu.xls]Sheet47!$A$22",([xenu.xls]Sheet47!$A$22))

=HYPERLINK("[matchnames.xls]Sheet3!$A$10","list")

and you get 0 for the display name if you try to show the content
in each other sheet's linkto address. So I put a constant in the second.