Excel links keep crashing

Question

Excel crashes a lot on my mom's slow computer. All 100 of the links in her sheet are broken when it crashes since they are all changed to the roaming folder. One master sheet on her computer links to one hundred separate workbooks. The documents are numbered 1 through 100. And I need to manually alter each link to go to the already-existing folder. I want to link the macro to a button for her when this occurs, therefore is there a method to do this with VBA. The same folder always houses all of the workbooks.

I've done a lot of searching on Google but haven't been able to discover anything that is even close to what I require. So, this is all new.

Answer 1

When the links in the master sheet break, you can create a VBA macro to change the links back to the current folder.

Sub UpdateLinks()
    Dim wb As Workbook
    Set wb = ThisWorkbook

    Dim lnk As Variant
    For Each lnk In wb.LinkSources(xlExcelLinks)
        wb.ChangeLink Name:=lnk, NewName:=Replace(lnk, "Roaming", "Existing")
    Next lnk

End Sub