Working with Oracle Smart View for Office Ad Hoc Analysis Working with Multiple Grids on a Worksheet Changing Connections in Multiple-Grid Worksheets Changing Connections in Multiple-Grid Worksheets Data source types: Oracle Essbase To change the connection of a grid in a multiple-grid worksheet: In the grid whose connection you want to change, select a range of cells, You must select a range rather than only one cell. Using Excel Name Manager, delete the associated named range. From the Smart View Panel, right click the application to connect to, and then select Ad Hoc Analysis.