Forum Discussion
Word Doc link to Excel (on Server)
https://social.technet.microsoft.com/Forums/en-US/f5951bd0-8caf-4b6a-af65-d975f681e31e/links-between-word-and-excel-do-not-work-if-source-file-is-not-opened?forum=word
Could also find this information about it.
Maybe they can help you further.
HYPERLINK function
For detailed information, click on this link - heading.
The HYPERLINK function creates a shortcut that jumps to another location in the current workbook, or opens a document stored on a network server, an intranet, or the Internet. When you click a cell that contains a HYPERLINK function, Excel jumps to the location listed, or opens the document you specified.
=HYPERLINK("http://example.microsoft.com/Annual Report.docx]QrtlyProfits", "Quarterly Profit Report")
o create a hyperlink to a specific location in a Word file, you use a bookmark to define the location you want to jump to in the file. This example creates a hyperlink to the bookmark QrtlyProfits in the file Annual Report.doc saved at http://example.microsoft.com.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)