Re-using Connections (the connection list keeps expanding)

P

Pondhockey

I'm trying to clean up a workbook with many worksheets that make connections
to the same few data sources. When I try to eliminate the duplicates and
re-use the same connection, the list of connections just grows. I get a
connection list like the following:
....
connection
connection1
connection2
connection3
....
Can someone direct me to an explanation?
 
Top