Smart View and Spreadsheet Add-in

When both Smart View and Spreadsheet Add-in are installed on the same computer, mouse actions are interpreted as Spreadsheet Add-in commands. If you want Smart View to control mouse commands instead, you can instruct Spreadsheet Add-in to respond to commands only in Essbase connections that were established through Spreadsheet Add-in.

  To enable Smart View to control mouse commands:

  1. Open Excel.

  2. Select Essbase, then Options, and then Global.

  3. Select Limit to Connected Sheets.

  4. Click OK.

    Smart View will control mouse commands unless the connection to Essbase is established through Spreadsheet Add-in and not Smart View.

Note:

You can connect to data sources from Smart View and Oracle Essbase Spreadsheet Add-in in the same workbook but not on the same worksheet.