Validating External Links In a SharePoint file

Click Workbook Links on the Data tab.

 

 

Click Refresh All

 

 

If any of the links throw errors

 

 

Click the three dots and then change source

 

 

And re-link the bad links (this will update the formulas)