Known Issues in Add-in for Excel 365

The Add-in for Excel 365 is updated regularly as issues are fixed.

The following table contains the open issues of the latest release. When an issue is fixed, it will be removed from the table.

Platforms: Excel desktop on Windows, on macOS, and on the web

Platform Reported in Description
Excel 365 desktop TOI-220 In Excel for desktop, all element names in Views that are interpreted as a number display a warning that a number is formatted as text. This warning has no effect and can be ignored. This is an issue from Microsoft and not from the Jedox Add-in.
All Excel 365 platforms TOI-172 Once you enable and use the Add-in for Excel 365, Excel's Undo / Redo features will be disabled, preventing you from undoing or redoing actions on that workbook (including non-Jedox operations). Other workbooks on which the add-in has not been enabled are not affected. This is a Microsoft 365 limitation that does not only affect the Jedox Add-in, and we are evaluating alternatives to alleviate this issue.
All Excel 365 platforms TOI-392 The Jedox data function PALO.SETDATA_BULK cannot be applied in the Add-in for Excel 365.
All Excel 365 platforms TOI-455 When conducting a search within the POV dimensions that are part of Lists used in rows or columns in the View, the search may return incorrect results. This issue only affects the dimensions included in the Lists.
All Excel 365 platforms TOI-474 Views created with Dynatables can be pasted with the Add-in 365. However, some features, such as expand/collapse, may not work.
All Excel 365 platforms TOI-515 The display to select levels from the context menu is incorrect for Virtual Dimensions as it always shows 4 levels.
All Excel 365 platforms TOI-518 The option to Select Expanded elements from the context menu does not work if it is triggered by the Insert Elements button. Workaround: select each expanded element individually.
All Excel 365 platforms TOI-520 If a View containing more than 50k cells is detached, executing a writeback operation will cause a #VALUE! error on all cells.
All Excel 365 platforms TOI-521 When creating an OLAP snapshot that contains a dynamic array formula, e.g. a Subset, only the first cell with the formula will be included in the snapshot. Note that static array formulas are not supported.

 

Known Issues in Add-in for Word 365 (preview feature)

Platform Reported in Description
Word 365 desktop TOI-517 In the Connection menu of the Jedox Add-inribbon, the Connect option is always enabled regardless of the connection status, while the Disconnect and Connection Manager options remain disabled.

 

Known Issues for Office JS Add-ins

The following table contains the documented issues that have been reported to the Microsoft Office team, as they are not related to the add-in but affect its functionality.

Platform Description
All Excel 365 platforms 5 MB limitation. The script requests on Excel Web (browser) are limited to 5 MB, which directly affects high resources request from the add-in like:
  • Pasting or splashing Views with 10k cells or more
  • Detaching Views with 5k cells or more
Web The add-in cannot be used if third-party cookies are blocked. Adjust the privacy and security settings of your browser.
Web The add-in cannot be used if the option to prevent cross-site tracking is enabled. Adjust the privacy and security settings of your browser.
Web The add-in cannot be used if multiple users log in to Microsoft 365 from the same browser.

Updated December 18, 2024