Excel Add-In Version 7.6.3

February 25, 2019 - Build 6719


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: When a PowerPoint presentation, which contains an external reference (link) to an Excel chart, is opened and the user clicks the Update Links option on the Microsoft PowerPoint Security Notice dialog, the following error is displayed:

    Sorry, we couldn’t find all the linked files. You might be able to re-establish the links by clicking the File tab, then clicking "Edit Links to Files" on the info tab.

    An Excel instance also remains open and the Task Manager must be used to end the EXCEL.EXE task. #2168

Spreadsheet Toolkit

  • Fixed Issue: When Option Explicit is used, the compile error “Variable not defined” is encountered for the EssVCascade function. To resolve the issue, the EssbaseVBAWrapper.txt has been updated to include the variable definitions for EssVCascade and EssVFlashBack. #2087

Styles

  • Fixed Issue: The Child member cell style is not applied to a member cell, which represents both a parent and a child, when the Parent member cell style is not active/enabled. #2170

    Before:

    image

    After:

    image
  • Fixed Issue: When both the Parent and Child member cell styles are active/enabled and the Child style has a higher precedence than the Parent style, the Child style is not applied to a member cell, which represents both a parent and a child. #2170

    Before:

    image

    After:

    image
  • Fixed Issue: When a member or data cell style is active (i.e. the checkbox for the style is checked) and a retrieve operation is performed, the style is applied to the qualifying cells. If the user then disables the style and performs a standard retrieve operation, the previously applied formatting for the newly disabled style is not cleared from the cells. #2171

VBA Editor

  • Fixed Issue: In the Visual Basic for Applications editor, a VBAProject is listed for each open workbook. When the Excel Add-In for Essbase is enabled and a workbook is closed by the user, the associated project still appears as open in the editor. #2049