MS Excel - existing connection strings correspond to which datatable
I have an excel spreadsheet that has 8 connections. I would like to know what connection string corresponds to which datatable/pivot table in excel. A solution in 2007 or 2010 method is fine.
Is this possible?
It is possible using the Data tab.
-- Click on Connections in the Data tab to bring up the Workbook Connections dialog.
-- Click on a connection in the list.
-- Click the link: click here to see where the selected connections are used