Use the Select Data Connection page to locate your previously created connection.

A data connection is a pointer to a data source. It contains information like the source name, location, and what, if any, credentials are required to access the source. When a connection is created it is typically saved to the My Data Sources folder inside the My Documents folder.

You can use the following types of connections:

  • .odc (Office Data Connection).

  • .dsn (Data Source Name).

  • .cub (SQL Server Analysis Services cube). This type of connection is available only if you are creating a PivotDiagram. For more information about PivotDiagrams see Create a PivotDiagram.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×