Creating a virtual link in Excel
 

Background: I have some Word files uploaded on SharePoint. I'm
creating an Excel Sheet that consists of all the procedural steps in an
upgrade process. Certain steps I can write in, but others need to link
to those Word files. After the project, no one will have access to
SharePoint so the files will be saved on the users' laptops.

Goal: I'm trying to create links in Excel that point to a folder saved
on my laptop and in that folder are maybe 10 Word files. My goal is to
create a variable in Excel so any user who has all those files saved on
their own PC can access this Excel Sheet and input the directory drive
as the variable. For example, if all the files are saved under
C:\Desktop\My Documents\SAP Project\Word File Links, then variable x
will equal that whole location. Then, I want each link to point to the
variable x + name of the Word file. That way, when the user goes
through the Excel Sheet step by step, they only have to input x once
and whenever they reach a link, they just click on it, and it opens
that Word file.

Problem: In Excel, I can't insert a hyperlink that allows me to add a
variable to a text cell. And when I try to Edit -- Links, Links is
grayed out and I don't understand why. Please help.