Search notes:

Excel: Data -> Get & Transform Data -> Existing Connections

Data -> Existing Connections opens the Existing Connections dialog which shows all connections that are currently available and all Excel table in the current workbook.

Tabs

Connections

The Connections tab shows connections
  • in this workbook
  • on the network
  • on this computer (.odc (and other?) files)

Browse for more…

Browse for more opens C:\Users\username\Documents\My Data Sources.

Tables

The Tables tab shows Excel Tables.

See also

The object workbookConnection
Connecting to data sources from Excel
The connection property of the QueryTable Excel Object.

Index