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)
- Whilst 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=wordCould 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)