Hyperlink address keeps changing

Todd Bardoni

Well-known Member
Joined
Aug 29, 2002
Messages
3,042
I created some hyperlinks to other files on a shared drive. When I email the workbook with the hyperlinks or copy it to another location the hyperlinks address changes to something like:-

. . /file.xls

instead of:-

S:Folder1\Folder2\file.xls

Why is it substituting part of the address with two periods and how can it be corrected?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
One way would be to use the =HYPERLINK() function...

store the root, such as "S:folder1\Folder2\" in any cell,
then have "file.xls" in another cell,

And your link cell would be =HYPERLINK(A1&A2)

That way the Excel hyperlinking and relative addresses won't be so "helpful" when you move it around. It's totally reliant on the actual data in the sheet.

If you don't mind typing the whole address over and over, you could also try using =HYPERLINK("S:folder1\Folder2\file.xls") and see if it changes when it gets moved...
 

Todd Bardoni

Well-known Member
Joined
Aug 29, 2002
Messages
3,042
I don't really like that solution. It seems like there should be a way to freeze the address so it doesn't do that. If there isn't a way then I will use an on open event to write the address.
 

Forum statistics

Threads
1,141,019
Messages
5,703,766
Members
421,315
Latest member
awaisnazir139

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top