Excel Add-In Version 7.1.2

July 25, 2016 - Build 5546

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 fixes:

  • EssVConnect and EssMenuVConnect Spreadsheet Toolkit Functions –An Error Code 5 is returned on subsequent calls after the initial call is successful and the function specifies a non-null userName argument and a null or empty password argument. The Sign On dialog displays appropriately to obtain a password from the user, and the user is allowed to sign on and accept the connection. On subsequent calls with the same argument values, an Error Code 5 is returned. #1512

  • Fixed issue with older classic Essbase add-in workbooks: When an older Classic Add-In file is opened, the following error is displayed: "Unable to handle Application_WindowActivation event. Index was outside the bounds of the array." In the Classic Add-In, and also in the Dodeca Add-In, the Essbase options settings are persisted as the defined name, EssOptions.

    At some point in the history of the Classic Add-In, the format of the EssOptions string changed to accommodate additional settings. In subsequent versions, when the older format was encountered, the Classic Add-In automatically updated the string. Starting with this release, the Dodeca Add-In now does the same. #1516

    An example of the older EssOptions string format is “1100000000130101_03N/A00”, and the same string updated to the more current format is “A2100001100121000011001101120_03(0)03#NA00”.

  • Fixed issue encountered with an ActiveX Combo Box: When the down arrow of an ActiveX Combo Box scroll bar is clicked twice (quickly), the mouse clicks are treated by the Dodeca Add-In as a double-click mouse action. #1517

  • Fixed issues with Unknown Members Task Pane in Excel 2010: 1) When the Unknown Members task pane is open and multiple workbooks are opened in the application window, closing a workbook results in an “Object not set to an instance of an object” error. 2) When the active sheet changes, the list of unknown members is cleared, and unknown members detected on the sheet are not displayed in the task pane. #1526

  • Fixed issue with attempting to perform a retrieve operation on a sheet that contains a used range with only a single column of values, which results in an “Object not set to an instance of an object” error. #1527

  • Fixed issue with mouse initiated Pivot operation: The wait cursor is not displayed when a pivot operation is initiated by dragging a member using the secondary mouse button. #1460