Enabling Compatibility with Smart View

If Oracle Hyperion Smart View for Office and Spreadsheet Add-in are installed on one computer, complete this procedure to ensure that Spreadsheet Add-in functions properly.

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

  1. In Excel, select Essbase, and then Options.

  2. 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 sheet being acted upon is connected to a data source other than an Essbase application and database (for example, a Oracle Hyperion Planning data source).

  3. Click OK.