Excel Add-In Version 7.8.6

December 03, 2020 - Build 7413

The supported versions of Excel include the following: Excel 2010, Excel 2013, Excel 2016, and Excel 2019. 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:

  • In the 7.7.0.6870 Release Notes, the Dodeca Spreadsheet Management System Integration section describes the ability to use named retrieve and send ranges in the Dodeca Excel Add-In for Essbase. Starting with version 7.8.6, only names defined at the sheet level will be supported. The referenced section has been revised to reflect this change. #2584

  • Client Timed Logging - To allow for additional (more verbose) messages, two levels of logged messages are supported with a new configuration setting, ClientTimedLoggerLevel: information and verbose. #2583

    image

  • A new function, SetAddInInteractiveDisabled, has been added to the Spreadsheet Toolkit. The function disables the user-interface layer of the Add-In. This function should ONLY be used when the macro executes processing, such as batch report generation or bursting, which does not require user interaction with the Add-In once the processing is complete. The user-interface layer cannot be re-enabled. #2653