Dear Sunny,
You should copy the file to new location and then breaklink the new
file.Don't breaklink the original file as it you would end up having
the original file without links.
For the warning message the "the links couldnot be updated , you
should set parameter updatelinks to 0 this will n
To break the links, record yourself doing a find and find next.
Search for [
Put that in a loop.
Insert in the code a copy, paste special value for that cell and then
search for the next one.
Eventually, the loop will end when it can't find [
Or if you are advanced enough in VBA you can use the s
