Hello, all. New to the forum, and a bit of a neophyte with hyperlinks. Please bear with me.
Trying to create hyperlinks in a workbook, that will link to a .pdf file. All files are on one server, but in different directories and subdirectories. The workbook will be emailed to different users, with the caveat that they will save to their desktops. The workbook IS NOT SHARED.
I realize I cannot use the right-click "Insert Hyperlink" option, because the path changes when emailed. Instead, I am typing the code =HYPERLINK("\\servername\file\folder") which works and does keep the path defined even when it is saved in different places. However, I need to be able to change the hyperlink name to something serviceable and when I right click on the link to "Rename Hyperlink" the hyperlink option is grayed out.
I'm assuming there is some additional code to add to the end of the =HYPERLINK command, but I don't know what it is. Or maybe it can't be done, I don't know. Any ideas?
Please keep any answers simple - I am not a tech person, just a simple admin trying to make a spreadsheet become a SuperSpreadSheet. Thanks!
Bookmarks