From the Document Contents pane, you can change connections in a Smart View document. This is useful when sharing an Office document between departments that point to different servers or when moving from a test to a production environment.
You can change the connection properties for all entities in a document that share the same connection information (for example, all worksheets or grids that point to the same application and database on a particular server). Or you can change the connection information sheet by sheet.
To modify connections from the Document Contents pane:
In the Document Contents pane, from the drop-down list box, perform an action:
Select a sheet from a selected document
Select a particular connection
Select All Connections
Select the Modify Connection link at the bottom of the pane.
Alternatively, right-click a connection name or sheet name and select Modify Connection. You can also modify connections as follows:
To modify a connection for all sheets in the workbook, select the top-level tree node connection name in Document Contents
To modify a connection for a specific sheet, select the connection name under the specific sheet-level tree node
The Edit Connection - URL page of the wizard is displayed.
In the URL drop-down list, select an existing connection or enter a new connection URL.
Click Next and in Edit Connection - Application/Cube, expand Servers, and navigate to the application and database to which you want to connect, depending upon the provider requirements.
Alternatively, select the Advanced Setup check box and manually enter the information for Server, Application, and Cube/Database, as the provider requires. Figure 1, Edit Connection - Application/Cube Advanced Setup shows the entries for connecting to an Essbase application and database.
The modified connection information is saved when you save the workbook.
Related Topics:
Shared Connections and Private Connections
Disconnecting from Data Sources