Changing automatically several links on several files in Excel

lndayong 

Perhaps a macro. It assumes that the workbooks to be updated are in a single folder, with no other workbooks.

Sub MultiUpdate()
    ' Path must end in \
    Const strPath = "C:\Excel\"
    ' Change as needed
    Const strFrom = "122021"
    Const strTo = "032022"
    Dim strFile As String
    Dim wbk As Workbook
    Dim wsh As Worksheet
    Application.ScreenUpdating = False
    strFile = Dir(strPath & "*.xls*")
    Do While strFile <> ""
        Set wbk = Workbooks.Open(Filename:=strPath & strFile, UpdateLinks:=False)
        For Each wsh In wbk.Worksheets
            wsh.Cells.Replace What:=strFrom, Replacement:=strTo, LookAt:=xlPart
        Next wsh
        wbk.Close SaveChanges:=True
        strFile = Dir
    Loop
    Application.ScreenUpdating = True
End Sub