Navigating Connections in the Data Window

The top of the Data window lists all of the connections in a given workbook. Simply select the data source you want to use and the Data window updates to show the corresponding fields.

You can resize the connection list area in the Data window to save space. When you resize to a limited vertical height, the list is converted to a drop-down list.

Each connection has an icon to indicate the type of connection. For example, the icon can indicate whether the data source is relational, a cube, or a data extract.

You can right-click the connections to access the commands that are on the Data menu. For example, you can right-click a connection and rename, export, or close it.