Office 365 - Delete connections in one go

I recently migrated from Office 2016 to office 365 and some GUI-functions seem downgraded as a result. In Excel 2016 I could do: Data -> Connections, a window would open, I could select them all and delete them. In 365, something to the right opens and I can only delete them one-by-one...

Surely there must be an easy way to select multiple/all connections and delete them?

Kind rgds,

Jaron

 

Question Info


Last updated December 9, 2019 Views 1,514 Applies to:

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

Hi Jarog,

The issue may occur due to corrupted system file. In order for us to assist you, please answer the questions below:

  • Aside from having Office 365, have you made any changes made prior to the issue?
  • What troubleshooting steps have you made so far?

To isolate the issue, we recommend to run this article: Repair an Office application. It contains troubleshooting steps if Office is not working properly and correctly.

We look forward to your response.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

That seems higly unlikely to me.

To be sure, in Excel 2016 there is a Ribbon command called "Workbook Connections", you can find this when you select to customise the Ribbon through Data -> Connections -> Workbook Connections. In Excel 365 however this command does not exist but rather has "Queries & Connections" at the same location.

Kind rgds,

Jaron

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

For us to have a clearer view of what is causing the issue. Can you please provide us a screenshot.

We also want to know, what happened when you are trying to delete the data connections on Excel? Also, we want to ask if you are using VBA or Macro while doing this?

Feel free to post back your response.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

OK, the first screenshot is Excel 365. Note how, after selecting Data -> Queries & Connections a sort of window opens to the right with "Queries & Connection" in larg bold font. You can only delete one query or connection at a time.

The second is from Excel 2016. After selecting Data -> Connections, a window opens listing the connections and here you can select one, multiple or all connections and press Remove in one go. That is what I am looking for.

This is, obviously, a superior way of managing connections and is what I hope to find in Excel 365.

No VBA, just GUI.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Jaron,

I am having the same issue. It appears that Microsoft updated Excel and has changed how connections are managed. Did you end up finding a method to delete multiple connections at once? This is an essential feature of Excel for my work and if I cannot find a work around I suppose I will need to uninstall the recent update that changed how this is managed.

A

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Upon checking all the possible work around to solve this issue, we suggest to post your query to this link. The community in this forum are expert and trained when it comes with Microsoft Excel.

Don't hesitate to post back if you have another concern.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Adrienne,

No. Well, I did do something with VBA in one workbook. With another, it is just one-by-one deletion now. Do you use Office 2016 or 365?

JR

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Seriously?

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Jaron,

Thank you for your reply. Office 365. I will let you know if I ever find a work around. 

And yes, it would be nice for Microsoft to at least acknowledge they changed the interface and lost this functionality in the process. 

Adrienne

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Reply In reply to deleted message

Hi oAnast,

Thanks. The thing is, support you have five connections listed that you want to delete. Is there a way to select all five and delete in one go?

In 2016 you can, in 365 I have not found a way.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.