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?

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.