Mass change in links

[SandsB]

My file has hundreds of links. One cell might have a link to 30 files. Each of these source files is in a folder named 2019 and all the file names have 2019 in them somewhere.
I copied the 2019 into a 2020 folder and need to update all the links to show 2020 instead of 2019 in the folder and file names. I get an error when I try to do a replace all - I think because it replaces the folder or file first and without both changes happening at the same time the link is invalid. How can I rename all at once?

 

[FatBoyClam]

In principal what you're trying to do should work - I'll gloss over the wisdom of having links to 30 different files in one cell for the moment.

are you trying to replace "2019" with "2020", or "19" with "20"?
Is there any chance there's an element of a filename/Cell reference that matches what you're searching for, but should not be changed.

For example one of your linked files in folder "2019" in the root of drive Z is called "Primary 2019 Source.xlsx"

You've copied the file to the 2020 folder, and changed the filename to "Primary 2020 Source.xlsx", however, one of the sheets in the file is called "Mix320192"

So the link is "Z:\2019\[Primary 2019 Source.xlsx]Mix320192!$A$1"

when you do the find/replace, it's trying to change that to
"Z:\2020\[Primary 2020 Source.xlsx]Mix320202!$A$1"
(note the sheet name has changed)

But that does not exist in the new workbook.