Results 1 to 1 of 1
2013-07-22, 20:45 #1
- Join Date
- Nov 2011
- Thanked 3 Times in 2 Posts
Data Connection build up "fix", Macro
I found this macro elsewhere, it seemed to fix a problem with the build up of Data Connections I never knew there were so many. Counted up 9 figures long in some cases. Deleting all one by one or even doing Shift-Arrow Down key to select more took forever to do to.
And it's in most, if not, all of my workbooks!
So this "fix" saved not just the day, the rest of the year deleting these Data Connections in Excel 2010
Sub delete_Connections() Do While ActiveWorkbook.Connections.Count > 0 ActiveWorkbook.Connections.Item(ActiveWorkbook.Connections.Count).Delete Loop End Sub