#CALC! errors - This calculation is not supported by this version of Excel

Created by Damien Zwillinger, Modified on Tue, 5 Sep, 2023 at 10:40 PM by Damien Zwillinger

Applies to:

  • Velixo NX
  • Every ERP


Description

When using Velixo NX, certain formulas can display #CALC!

 

Text of Message

#CALC!  This calculation is not supported by this version of Excel.

 

 

Cause

This is a known issue with current versions of Excel.

 

Certain Excel functions (e.g., BYROW, MAP, MAKEARRAY, etc.) do not support being used with various user-defined functions ("UDFs" - such as those in Velixo NX).

 


Workaround

 

Method 1 - redesign the report (RECOMMENDED)

The recommended method to avoid the issue is to redesign the report to not use the Excel functions which do not support the Velixo NX UDFs.

 

In this way, the Velixo NX functions will return the data requested.

 

 

Method 2 - use Velixo Classic

If it is absolutely necessary to use the Excel functions that do not support the Velixo NX functions, the only known workaround is to use Velixo Classic for Excel for Windows.

 

The Velixo Classic UDFs can be used with the Excel functions in question.

 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article