My office is revamping its hard drive and many files are being moved to new
folders with new paths.

Is there any way that links in Excel can unbroken or at least automatically
updated?