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:
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).