Hyperlinks in Excel

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?
 
C

Charles Maxson

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\"
 

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

Preventing hyperlinks and vlookups from breaking 5
EXCEL HYPERLINKS STOPPED WORKING 4
Hyperlinks 1
Hyperlinks in Excel Woprksheet 3
Preventing broken hyperlinks and vlookups 2
Preventing hyperlinks and vlookups from breaking 5
Free pdf creator which can render hyperlinks? 2
Hyperlinks in Excel 2007 1

Top