Forum Discussion

Jonathan_Borg's avatar
Jonathan_Borg
Copper Contributor
Jun 21, 2021

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...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jun 21, 2021

Jonathan_Borg 

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_Borg's avatar
Jonathan_Borg
Copper Contributor
Jun 21, 2021

NikolinoDEThere are no issues Excel to Excel links. The above problems arise when linking Word to Excel tables.

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jun 21, 2021
    Isn'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_Borg's avatar
      Jonathan_Borg
      Copper Contributor
      Jun 22, 2021
      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=word
      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        Jun 22, 2021

        Jonathan_Borg 

        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)

Resources