hyperlinks in excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way to make hyperlinks in excell 'relative'?
i'd like to copy files without having to change the link.
 
Hi Tom,
This is an Excel group, if you have excell perhaps you should post in
an excell group, if there is such a thing.

An example of your problem would have been in your best interest
in getting a solution. Rather than forcing someone to guess.as to
your particular problem (and version of Excel/ I'm guessing you have
Excel 97 or Excel 2000, since Excel 2002 does not require the pathname.
The follow gets around having to specify a pathname for the same workbook...

=HYPERLINK("#C5",C5)
=HYPERLINK("#Sheet34!E6",Sheet34!E6)
=HYPERLINK("#'My Sheet'!E6",Sheet34!E9)

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

For more information see
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: =HYPERLINK("#C5",C5)
=HYPERLINK("#Sheet34!E6",Sheet34!E6)
=HYPERLINK("#'My Sheet'!E6",Sheet34!E9)
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks changed by Excel again! 5
Activating hyperlinks 3
Maintaining hyperlinks when I move Excel files to another location 1
Maintain hyperlink when moving excel files 1
hyperlink troubles 1
ADRMS Breaks Excel Hyperlinks (when read only) 1
Change hyperlink throughout excel 1
change hyperlinks from relative to absolute 1

Back
Top