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?

Answers


It is possible using the Data tab.

Try this:

-- 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


Need Your Help

Java Delegates?

java delegates

Does the Java language have delegate features, similar to how C# has support for delegates?