hyperlinks - file location - can I change it

D

Dianah

I'm creating hyperlinks with a list of documents in an excel spreadsheet.

Is there a way to tell Excel where to look when I try to add the hyperlink.
The link it only to a file on a network directory ... not to a website.
It's a real time-waster to have to change it 200+ times. I did change where
it looks for documents, but that was ineffective. It still goes to the same
"wrong" location. It only goes to the drive/directory that the excel file
is located ... arghhhhh!

Any ideas.
Thanks in advance.
Diana
 
D

Dave Peterson

When I do this, I put the server/folder names in a cell (A1) and hide that row.

Put some nice headers in A2:B2
Then I put the filenames in A3:A999

and I use this formula in b3:b999
=hyperlink($a$1&a3,"Click me to view")

When the server changes (or folder), I fix $a$1 and walk away happy.

If you want to try this, you might be able to use David McRitchie's code at:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Conversion of cell object Hyperlinks to HYPERLINK Worksheet Function



But if you want to just convert in place, look for:
Fix Hyperlinks (#FixHyperlinks)
(on that same page of David's site)
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
 
D

Dianah

Hmmmm ... looks interesting ... and worth a try. I'll see what I can do
with it ... and see if I "can" do it myself. It really looks worth figuring
out. If I run into serious (head-banging) frustration trying to figure it
out, I'll let you know, otherwise, I'll be a happy camper.
Thanks a bunch.
Diana
 
Top