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:
In Excel, select Essbase, and then Options.
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).