Office 365 - Delete data connections in one go

Hi all, first post here as recommended by Philip Pio from Microsoft (https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_365hp/office-365-delete-connections-in-one-go/3011...

excel

Pablo R. Ortiz

Feb 04, 2018

you can use this vbscript in a Macro button:

Sub Remove()
Dim connection As WorkbookConnection
Dim query As WorkbookQuery
On Error Resume Next
For Each connection In ThisWorkbook.Connections
    connection.Delete
Next
For Each query In ThisWorkbook.Queries
    query.Delete
Next
End Sub

Jaron Rosegg

Copper Contributor

Feb 06, 2018

Yes, it is possible to delete the connections files. However, that does not delete the connections as known to the workbook. At best you will get a message that Excel failed to refresh the data.

Pablo R. Ortiz

Steel Contributor

Feb 06, 2018

Correct, that takes us back to the workaround script ;-)

Forum Discussion

Office 365 - Delete data connections in one go