Forum Discussion
Jonathan_Borg
Jun 21, 2021Copper Contributor
Word Doc link to Excel (on Server)
Good morning, Setting up this post as I was unable to identify any solutions online; I am currently trying to set-up and link a set of tables from excel to the word (printable) version. Up ti...
NikolinoDE
Jun 21, 2021Gold Contributor
I am not a specialist, so send you this information as it may be of interest to you.
If not, please ignore :).
Description of link management and storage in Excel
In Microsoft Excel, you can link a cell in a workbook to another workbook using a formula that references the external workbook. When this link is created, it may use a relative path. With a relative link, you can move the workbooks without breaking the link.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- Jonathan_BorgJun 21, 2021Copper Contributor
NikolinoDEThere are no issues Excel to Excel links. The above problems arise when linking Word to Excel tables.
- NikolinoDEJun 21, 2021Gold ContributorIsn't the problem the same?
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