Enabling Compatibility Between Spreadsheet Add-in and Smart View

If Smart View and Spreadsheet Add-in are installed on one computer, you must complete this procedure to ensure that Spreadsheet Add-in functions properly alongside Smart View.

  To enable compatibility between Spreadsheet Add-in and Smart View:

  1. Start Excel.

  2. Select Essbase, and then Options.

  3. In Global, under Mouse Actions, select Limit to Connected Sheets.

    When Spreadsheet Add-in and Smart View are installed on one computer, and this option is selected, mouse clicks are ignored by Spreadsheet Add-in if the worksheet being acted upon is connected to a data source other than an Essbase application and database (for example, an Oracle Hyperion Planning, Fusion Edition data source).

  4. Click OK.