excel links unable to refresh on Mac M5

I have to re update the link and refresh all it works but if I close the excel it won’t work and I need to relink for 50 spreadsheet.

It is probably caused by broken workbook links, unavailable data services, or network restrictions, support.microsoft.com/en-us/excel/manage-workbook-links