How to remove edit link from all workbooks

[Abhijeet]

Hi

I have 200 excel files in that few are edit link i want to remove those files edit link because when i run macro then these files are open then pop this message

I want to by pass this message so please tell me how to delete this edit link from all files

 

[Marc L]

Hi !

It may depend on how do you open files ?
And as often all is in VBA inner help …
​

 

[Abhijeet]

I do not want to change my current macro i want to design new macro to break this link from all files