What do you mean by fix it. Excel is telling you that you can open the workbook, albeit with missing information - apparently hyperlinks. If Excel were able to recover the informtion it would have done so. Sometimes these things happen but why is rarely known.

Do you have a recent backup of the file? i.e. have you got the autorecover and autosave options set in the Excel app?

I doubt you can fix this in the way you - certainly I'm not aware of anything.