Setting the Active Connection for a Sheet

You can connect to different data source providers on the different sheets within a workbook by setting the active connection for each sheet.

To set the active connection for a worksheet:

1. Create a named connection by saving a shared or private connection as a private connection.

   This process is described in Saving Connections as Private Connections. Once these connections are available to you, you can set the active connection for a sheet to one of these private, or named, connections, as shown in the following steps.

2. Open a workbook and connect to a named private connection.

   Optionally, you can begin without connecting. You will be asked for your login credentials in the next step.

3. In the Smart View ribbon, select Connections, then Active Connections, and, if it is not already selected, then select the check box next to the connection name.

   If you did not connect in the previous step, then you will not see a connection name in the Active Connections list.

   If you do not see the connection name in the Active Connections list, then select Connections, then Named Connections, and then select the check box next to the connection name. You can then view the active connection for the sheet by selecting Connections, and then Active Connections.

4. Optional: Switch to another sheet and repeat the above steps to set the active connection for that sheet.