Fix Excel Server Errors When Updating Linked Workbooks in SharePoint

Launch Microsoft Excel, click on the File tab in the top-left corner, and select Options at the bottom of the menu.

In the Excel Options window, click on Trust Center in the left-hand navigation pane, then click the Trust Center Settings button.

Select External Content from the left menu. Under 'Security settings for Workbook Links', select 'Enable automatic update for all Workbook Links'.

Click OK to save the changes, close Excel completely, and reopen your workbook to see if the SharePoint links update successfully.

Go to the Data tab on the Excel ribbon and click on Edit Links or Manage Workbook Links.

Review the file path for the problematic linked workbook to ensure it still points to the correct SharePoint URL.

If the file has been moved, click Change Source, navigate to the new location in your synced SharePoint folder, and select the source workbook to re-establish the connection.