Forum Discussion
Word Doc link to Excel (on Server)
NikolinoDEThere are no issues Excel to Excel links. The above problems arise when linking Word to Excel tables.
I searched the internet for a long time and found nothing like it. Can't help, unfortunately.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
- Jonathan_BorgJun 22, 2021Copper ContributorWhilst in theory the two should work similarly, we have no issues with links between two Excel files (even when they have different paths on the network). The below is a similar query that I found online. Tried the solution, however, to no avail...
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- NikolinoDEJun 22, 2021Gold Contributor
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)