Breaking links between workbooks

[wlbamc]

Hi, I have a workbook with links to 3 other workbooks, unfortunately my work decided to change the shared drive from drive I to drive S so my links now state they cannot be found, I have gone into data and edit links but it will not let me either change or break the links. Any help gratefully received.

 

[Trevor G]

You could try a little bit of VBA if it is only the Drive letter that has changed. I am assuming they are inside a formula. Example shown below:

Sub ChangeLinks()
ActiveWorkbook.ChangeLink "I:\documents\book1.xlsx", _ "S:\documents\book2.xlsx", xlExcelLinks
End Sub

Not tested though.

 

[wlbamc]

You could try a little bit of VBA if it is only the Drive letter that has changed. I am assuming they are inside a formula. Example shown below:

Sub ChangeLinks()
ActiveWorkbook.ChangeLink "I:\documents\book1.xlsx", _ "S:\documents\book2.xlsx", xlExcelLinks
End Sub

Not tested though.

Great thanks, worked a treat

 

[Trevor G]

Pleased to help and thanks for letting me know.