Deleting External Connections

Hello rjj920,

This macro will remove them. Add a New VBA module to your workbook and paste this code into it. You can run the macro using the ALT+F8 while in Excel to bring up the macro dialog.

Sub RemoveConnections()

    Dim qt As Object
    
        For Each qt In ActiveSheet.QueryTables
            qt.Delete
        Next qt
    
End Sub