Forum Discussion
Lucas Fernandes de Jesus
Jan 22, 2018Copper Contributor
Deleting many connections at the same time on Excel
Hello!
I was trying to delete many connections at the same time at "Data<Queries & Connections" tab, but when i click to open the "Connection" tab, i just cant select as many as i want do delet...
Lucas Fernandes de Jesus
Feb 06, 2018Copper Contributor
I totally agree with you, Jaron!
I also used a VBA code to delete all my conenctions, and it worked, but the document still working very very slow.
Well, it'd be awesome if they bring back the old query & connections tab, where we could select as many as we would to delete.
I also used a VBA code to delete all my conenctions, and it worked, but the document still working very very slow.
Well, it'd be awesome if they bring back the old query & connections tab, where we could select as many as we would to delete.
Jaron Rosegg
Feb 06, 2018Copper Contributor
Just to be sure, if it is about Queries, then there is actually a way to do this (Ortiz pointed me to it in the other thread): Data -> Get Data -> Launch Query Editor. Here you can select queries and delete in one go. Not as clean and quick as it used to be but at least something.
For connections we're SOL.
- Lucas Fernandes de JesusFeb 06, 2018Copper ContributorI didn't know about this way to delete Queries, i'll take a look. Now, talking about connections... Err... Waiting for updates