Fixing #ref error instead of deleting

Hello,

So my computer restarted before I saved my excel workbooks I was working on, and now I have #ref errors where I was referencing another sheet from another workbook. I made sure to resave the workbook in the exact same location with the exact same name so that in theory it should be find to find all of the information again. However I still have the #ref errors. Is there any way to refresh the connection other than going through each cell individually to remove #ref and relink them one by one?

Thank you