Modifying Connections within an Office Document
From the Document Contents pane, you can change connections for Oracle Smart View for Office objects within an Office 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: