Report displays #N/A until each cell is edited

Created by Damien Zwillinger, Modified on Wed, 13 Sep 2023 at 11:32 PM by Damien Zwillinger

Applies to:

  • Velixo NX
  • Velixo Classic
  • Every ERP


After refreshing or when working with a report, instead of all the values being displayed...

... all the Velixo functions display #N/A...

... and they have to be edited one function at a time to get data to display:


Excel includes an Advanced Option which allows a user to use Lotus 1-2-3 style key combinations:

Use of this feature places Excel in an emulation mode that is not compatible with any version of the Velixo add-in.




Excel's Lotus Compatibility Settings must be disabled (unchecked):


After doing so, you must save your file, close all instances of Excel, and then restart Excel to load it without being in emulation mode.

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 atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article