Hyperlinks

[Sue]

Hi

Can anyone help me with hyperlinks. If I insert a
hyperlink to a file on our computer network, the link
works fine.

However, if I then burn that spreadsheet onto a CD with
all the files that are linked to, the link doesn't work
because it is still looking for the network path.

Is there anyway of inserting links and making sure that
they work, even if you copy and burn from a network to a
CD.

All help most appreciated.
Many thanks
Sue

 

[David McRitchie]

Hi Sue,
Specific examples would always help, but take a look at
Worksheets in VBA Coding and in Worksheet Formulas
http://www.mvps.org/dmcritchie/excel/sheets.htm

I'm not on a network but the following might get you started,
be sure to look at the above page. If you have a network
example that works, reply in the thread and I'll include it as well.

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

Without the # sign you had to include the workbook name even it the
link was in the same worksheet.
=HYPERLINK("[vlookup.xls]'" & A5 & "'!C5","'" & A5 & "'!C5")