hyperlinks in a file located within a shared folder do not open when opened by others

Pike_Constr

I uploaded a folder from my network to a shared dropbox folder. The folder uploaded contains branch files to support the hyperlinks I created . Within my dropbox folder, If I click on the hyperlinks they work/open.  Once I send out a link of my dropbox folder to be share with someone, the hyperlinks within the folder files do not work/open for the recipient . How can I get the hyperlinks to work for others to view? 

Walter

Hey there @Pike_Constr -how are you today?

From what I understand you're using hyperlinks to point to your own files on your own computer and you'd like them to work for other collaborators of the shared folder in question - please correct me if I got anything wrong. Read on for more information and possible workarounds:

In Microsoft Excel, you can create links in a workbook to another workbook or file on your computer using a formula that references an external location . When this link is created, it points to a location on your own hard drive.

 

When your workbook is downloaded onto another's computer, the locations that your formula points to are no longer there. The link in the workbook is looking for a specific place, for example /Your_Computer/Your_User/File, and that location is no longer accessible from a different computer.

 

To learn more about relative and external paths in Excel please consult the following Microsoft support page:  https://support.microsoft.com/en-us/help/328440/description-of-link-management-and-storage-in-excel

 

While we are unable to support you in configuring Microsoft Excel to work the way you would like, we suggest perhaps using wildcards in your formulas. 

 

Wildcards, such as "%HOMEPATH%”, if other users have the Dropbox folder located in the default location, would let you point to a location without having to worry about different usernames in the path.  

 

I hope this helps and please let me know how it goes!