This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 30%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Hi,
Is it possible to delete a power query via Excel interop? Or stop it refreshing?
My process is Open spreadsheet, Refresh all (get the latest data from SQL Server), Delete connections, send to internal customer.
But I do not want the power query to still be there.
Alternatively is there a different option from power query (and VAB) to call a SQL Stored proc.
Thanks
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 75%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Hi, I have a similar problem to yours I think, After fetching the data I need to return to the internal client a copy of the modified Excel file, but I need to remove the query from the Queries & Connections tab so the client doesnt see them at all. Would you mind sharing how you removed them from being visible - I removed the connections so even if its refreshed it wont work, but I want him to not be able to see it. Would you mind helping me out if you are able to.
Answer accepted by question author
Hi,
Sorry. This is straight-forward. Amend a connection from table to sql to call a stored proc. My existing code will work, which deletes all connections in an excel workbook.