Existing Connections

[Godders199]

Hello, I am doing a little house keeping to tidy andhopefully speed up so spreadsheets, I clicked on Existing Connections and gothundreds of reportserver connections listed. if I click on any of them its says noconnection. As the spreadsheet doespull information from a report server, is this purely a record that can bedeleted? Is it doing anything that might slow the spreadsheet down. ?

 

[mole999]

I think if they are auto created then a routine will clear them out

 

[SpillerBD]

During a Refresh, I imagine Excel will try and evaluate the connections. There are other things that could slow a sheet down, large number of array formulas on big arrays and watch out for conditional formats.

Unused Connections should be deleted.
Connections for linked cells in a different workbook can get bothersome to maintain and are hopefully not the case you are dealing with.

 

[Godders199]

thanks both, I have created a duplicate version so will play with the history. its purely when opening the file there is a delay, there 3 connections, this one to a report server which refreshes whe button is pressed which seems to create this history and two, to a sharepoint, which only refreshes as part of the VBA coding. I am just working through everything that might be happening when the file is opened,.

 

[mole999]

useful routine here > https://www.mrexcel.com/forum/excel-questions/528396-vba-remove-connections.html