I m not sure how it helps finding the links. I've already tried fixing the excel workbooks through help on another forum without luck. Reason being that some of the workbooks have a very large number of cells, sheets, macros, data validation lists, etc.
Simply breaking the links does work on some of the linked files, but on all, due to some of the workbooks being password protected i guess.

Also i can see how it would prevent me from having to reply to all the error messages but it still does not help the fact that i would like to not have to have Word open all the 50 linked excel files every time i want to open the word document as the process takes a very long time.