Excel Changing Link to other Worksbooks

[gavs73]

Hi

Would appreciate and help and advice.

I have a file with thousands of links in cells to other workbooks, I need to change the filepath to these links, which I've done with a find and replace, despite the updated filepath being correct, it is still opening the Open file dialogue box for every link and asking me to click on the file, is there a route around this ?

Thanks
Gav