Hyperlinks in Excel

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I am putting together a workbook and would like to link to
some text documents. The problem is that all the workbooks
and associated folders will eventually reside on a
different(yet unknown) server then the one I am working at.
How do I insert and designate the hyperlinks so that they
work when all folders/files are moved to final destination?
 
One consideration would be using Hyperlink function over native hyperlinks,
then you could set a path and change it easily when that occurs....

=HYPERLINK(A1&"file.txt","file.txt")

where A1 = "z:\ourfileshare\"
 
Back
Top