ChangeLinks results in directory prompt for each link

The macro below is to update each link flagged with a "Yes".

However, running the macro resulted in getting a directory prompt for each link,
although all of the old files were in one folder and all of the new files were in their own separate folder.

Both OldLinks and NewLinks are filenames with full paths.

Do I need to change directories or something?

PHP Code: 

Sub UpdateLinks()
    Sheets("Link Summary").Select
    LinkCount = (Range(Range("A2"), Range("A9999").End(xlUp)).Rows.Count - 5) / 2
    
    Rows("1:1").Select
    Selection.Find(What:="Update?", After:=ActiveCell, LookIn:=xlValues).Activate
    Set Changes = ActiveCell.EntireColumn.SpecialCells(xlCellTypeFormulas, 23)
    Changes.Select      '''This is a single column containing a Yes/No flag
    
    For x = 1 To LinkCount
        If Changes(x) = "Yes" Then
            OldLink = Range("A" & Changes(x).Row).Value
            NewLink = Changes(x).Offset(0, 1).Value
            ActiveWorkbook.ChangeLink Name:=OldLink, NewName:=NewLink, Type:=xlExcelLinks
        End If
        Changes.Select
    Next x
    
    MsgBox "Finished!"

End Sub