Server Error when linking Excel Workbooks.

Question

Hello,

I'm trying to use the link between two workbooks on sharepoint online and i'm receiveng an error saying that is impossible to update the links: "It was not possible to obtain updated values from a linked workbook".

When I push the button "Menage Workbook Links" the error I see from the workbook I'm trying to recover data from is: "Server error"

I couldn't attach pictures to this post also. Don't know if is happening anything to microsoft servers.

Answer 1

You may upload your picture in a new reply. Share the error will help us to determine the issue.

Workbook link article for your reference.

Workbook Link support coming to Excel for the web - Microsoft Community Hub

Here is my test.

Answer 2

Thank you for your fast reply.

It follows the screenshots (they are in portuguese language)

Answer 3

Is there a notice for enable content?

You may try

1. In Excel, click the File tab.
2. Click Options > Trust Center > Trust Center Settings, and then click External Content.
3. Click the option that you want under Security settings for Workbook Links:
   • Enable automatic update for all Workbook Links (not recommended)

Block or unblock external content in Office documents - Microsoft Support

If it still doesn't work, issue could be on SharePoint side.