Update and then break external links to another workbook

Originally Posted by tatiana_

Thanks for the help!

AlphaFrog, i have issue with your procedure...Once i run the macro, it asks me with dialog window to show the location of the file (data to be updated from).
And same repeated with each link.
How can i avoid it?

I don't follow what you are describing.

Are you asking that the code is displaying a file dialog and you want to cancel it and exit the procedure? If yes, show that part of your code.