Excel Hyperlinks

trevolly

Board Regular
Joined
Aug 22, 2021
Messages
66
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I've created a Daily Log workbook and in it I've created some shortcuts to forms (mostly made in excel). They are a simple hyperlink attached to a shape, with the hyperlink pointing to the file to open (right click on shape, insert link, existing file or webpage).

My company works with network drives and the files I've linked to are stored on one of these network drives. The issue is that when the staff (over the years) have mapped these drives some of them have given the drive a different name to others, i.e.: some have the drive as X, some Z etc..... Is there any way of the hyperlink seeing multiple locations so as to "catch" these people rather than them getting a "Cannot open specific file" error and then moaning and blaming the worksheet. If not I'll just tell them all to remap the drives with all using one specific drive name.

Once again thanks all
T
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

queuesmef

Board Regular
Joined
Dec 19, 2016
Messages
58
It would probably be best practice to use fully qualified path and not what other people name their mapped drives. Example: \\MyNetwork\Marketing\Prospects folder is better than h:\
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,112
Messages
5,768,167
Members
425,458
Latest member
Jaspal1996

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