Excel COM Add-in Troubleshooting

The compatibility of Jedox Excel Add-in with other add-ins for MS Excel / Office cannot be guaranteed, and in specific cases, incompatibilities may occur.

When using the live preview of Paste Values from the context menu in Excel, Jedox formulas might stop working or can't be calculated anymore and show an #NA error. To force Excel to recalculate the formulas, use the keyboard combination CTRL + ALT + F9.

If you close Excel and answer the question "Do you want to save the changes…“ with Cancel, the Excel Add-in displays #VALUE! in the cells with PALO.DATA functions. Close Excel and restart it to fix this behavior.

1. Create the folder C:\procdump\dumps.
2. Download procdump.zip from https://docs.microsoft.com/en-us/sysinternals/downloads/procdump.
3. Move procdump.zip into C:\procdump and extract it there.
4. Stop all Excel processes.
5. Execute "cmd" with admin rights:
   • Click the start icon and click in the search box.
   • Type cmd into the search box. You will see the cmd (Command Prompt) in the search window.
   • Hover the mouse over the cmd program and right-click.
   • Select "Run as administrator".
6. Go to C:\procdump.
7. Execute „procdump -accepteula -ma -i c:\procdump\dumps“. This command activates the creation of a dump in C:\procdump\dumps whenever Excel crashes. And this dump can be analyzed to find the reason for the Excel crash.

If you need no more dumps of Excel crashes, the command „procdump -u“ deactivates the creation of dumps.

When you use Excel 2010 and you open an Excel file with Palo functions from Outlook, Excel disables the recalculation of the workbook by default. As a result, the Palo functions don't work correctly. In this case, save these files on your hard disk before opening them.

To receive no extended computing time, your VBA_code should include lines 2,3, 6, and 7:

1
2
3
4
5
6
7
8
Sub VBA_code() 
On Error GoTo Cleanup '
Excel.Application.EnableEvents = False ' 

<Your VBA code>
 Cleanup: ' 
Excel.Application.EnableEvents = True ' 
 End Sub

If you use PALO.DATAC() or PALO.DATAX() in your Excel file, then you should use

Application.Run("PALO.CALCSHEET")

instead of

ActiveSheet.Calculate

in the VBA code.

This problem is due to a recent change in Excel functionality, which inserts an @ into formulas. To solve this problem, after expanding the cell range, remove the @ operator manually from the formula and press CTRL-SHIFT-ENTER.

When multiple monitors are being used, sometimes the Jedox Assistant is displayed very small, and therefore cannot be properly visualized. In this case, right click on it and select "Maximize window". It will then be displayed correctly.

Antivirus software such as ESET may interfere when Excel Add-in tries to connect to Jedox instances using HTTPS. This happens because ESET runs a man-in-the-middle HTTPS attack to read all traffic going in and out from an endpoint.

HTTPS connections still work in browsers because ESET installs its own certificate in the operating system. However, Excel Add-in does not use the operating system's list of trusted certificates.

Work around this issue by following one of the options below:

1. Deactivate HTTPS-MITM in your antivirus completely (for ESET, go to Setup > Advanced Setup > Web and Email > SSL/TLS, and turn off the SSL/TLS protocol filtering).

2. Contact your IT team to remove your Jedox instance from HTTPS-MITM measures.

3. Contact your IT team to get the certificate of your antivirus and put it in Jedox > Options > General Options > SSL Certificate.

Cross-version compatibility between Excel Add-in and In-Memory DB cannot be guaranteed and is not officially supported by Jedox. Ensure that the version of your Add-in client matches the Server version.

All features of the Excel Add-in can only be used in a single Excel instance. For each additional initialized Excel instance, the error message "The browser component was not initialized successfully..." will be displayed and all features on these instances that use Jedox Web dialogs will not be available. The functionality of these features is retained in the first initialized Excel instance.

The Excel COM Add-in does not support Excel dynamic array formulas. Workbooks that contain such formulas may fail during an OLAP snapshot, a snapshot export, or in offline mode. Ensure that every array you use in your workbook is a legacy CSE array. For more information, see dynamic array formulas vs. legacy CSE array formulas.