Then, your plan is to go through 10,000 files. I said originally, fix the
links in one pass. Then go vack again to every file and check the links if
they are good. the ones that are not good replace the formula with the value
from value2.

Range("A3")=Range("A3").value2 with cells that have links.
Also set the formula in the cell to a blank string
Range("A3").formula = ""


" wrote:

Thanks Joel,
All together there are around 40,000 files of which about 10,000 have
links, I only need to look at the linked files I now have a list of
all the linked files, I need a way of going through the 10,000 files
and where the link is invalid break the link and maintain whatever
data is there and where the link is valid leave those links in the
workbook, using the global search and replace method on the test files
on the test server with the new mapping has corrected the link paths
but any path that is invalid and would have been invalid on the
original server had they been updated recently gives #REF errors
everywhere.

I hope this makes more sense

Cheers
David