Working with Oracle Smart View for Office Ad Hoc Analysis Multiple Grids on a Worksheet Creating Multiple-Grid Worksheets Creating Multiple-Grid Worksheets Data source types: Oracle Analytics Cloud - Essbase To create a multiple-grid worksheet: In Excel, connect to an Essbase data source. From any location in the worksheet, select a range of cells (You must select a range rather than only one cell). From the Smart View Panel, right-click an application, and then select Ad Hoc Analysis. Note: Multiple-grid worksheets are not supported for Smart Slices. When prompted to change the worksheet to support multiple grids, select Yes. To create a second grid on the worksheet: Select a different range of cells. From the Smart View Panel, right click an application, and then select Ad Hoc Analysis. Repeat step 5 as necessary to add grids to the worksheet. Note:Starting in Oracle Smart View for Office11.1.2.5.400, the creation of multiple-grid worksheets using refresh is no longer supported.