Hi Everyone. Apologies if this is in the wrong section

One of the users at a site i manage has a Excel doc that is used for management of certain confidential data.
As in it lists a persons details name etc. one of the things done is in sections such as security check it will have a security check certificate number. and that number will be made into a hyperlink to the location of a scanned copy of the security check certificate. Every time an edit is made the document needs to be saved as. a new document with who made the edit.

with the start of the new year it got saved to a 2024 folder. which has broken all of the hyperlinks by adding the current folder to the hyperlink. Im trying to find the best way to bulk edit all the hyperlinks just to remove the addition to the folder to the hyperlink. I have tried find and replace and it is unable to do that.

I am only allowed to troubleshoot the issue on this doc when an authrised person is present.

Any advice would be appreciated