Excel Add-In Version 7.1.4

August 24, 2016 - Build 5582


The supported versions of Excel include the following: Excel 2010, Excel 2013, and Excel 2016. Although not explicitly supported, there are currently no known issues when using the add-in with Excel 2007.

The supported versions of Essbase include 9.3.0 and higher.

This release contains the following changes:

  • Fixed Issue: Opening an Excel from the file system that is already open in Excel and contains changes, when at least one other Excel file is also open, results in the following error (along with the same error for several other ribbon controls): Unable to refresh the ribbon control UndoEssbaseOperationButton.

    EssbaseExcel.IsWorksheetName.Get failed. Exception from HRESULT: 0x800401A8 #1537

  • Fixed Issue: In Excel 2013 and Excel 2016, the EssOptions (and related Essbase options) defined names are added when the workbook is opened. The defined names should only be added when a sheet-level option changes or when the sheet is connected. #1538

  • ClearEssbaseCredentialsOnLastDisconnect Configuration Setting - After disconnecting the last connected sheet, this setting controls whether a user’s login credentials (specifically the user’s password) must be re-entered before performing any action or operation that requires a connection to Essbase. By default, the user’s password is not retained after the last connected sheet is disconnected. #1540