We have a series of workbooks that are updated using MSQuery. We want to save these as archives and remove the connection to MSQuery so that they are no longer refreshable.
Dim qt As QueryTable
Dim wks As Worksheet
For Each wks In Worksheets
For Each qt In wks.QueryTables
qt.Delete
Next qt
Next wks
Set qt = Nothing
Set wks = Nothing
To break the connection by hand, in Excel 2010, select any cell in the query table, then Table Tools contextual ribbon | Design tab | External Table Data group | Unlink button.
There's a similar command in earlier versions of Excel.
We have a series of workbooks that are updated using MSQuery. We want to save these as archives and remove the connection to MSQuery so that they are no longer refreshable.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
