Delete queries and connections in Microsoft excel: Quickest Method

"Connections" remain and need to be deleted one by one.

POOF, underlying queries are gone, I had been looking for this particular solution for a while, Thank you!

dhanyavad Sohail. Bahut helpful!

Doesn't work for connections. I don't have queries but I do have 14 connections, I can delete 1 at a time but same method described here doesn't work in my case. I have no custom xml data.

Thank you so much!!!

Great hack to get rid of annoying pop up of data link

What if you have other connections like pivot tables. Will it delete them as well?

very nice videos. thanks for showing that. is there a way to automate that?

Great tip

Genius !!
Thank you !!

Awesome, much needed video. thanks for upload

Hello Sohail, thanks for your video. You can also use: "ActiveWorkbook.Queries("QueryName1").Delete", after you get the info you need from query, if you are using vba.

ABSOLUTELY AMAZING, i used to do this one by one, but now had almost 1000 queries to remove and though "damn I need to find a solution" - THANK YOU SO MUCH, GREAT JOB!!!

Which version of Excel?

Àwsome