Functions appear as text and do not refresh

Created by Harry Lewis, Modified on Tue, 16 Jul at 9:33 AM by Gabriel Michaud

Applies to:

  • Velixo Classic
  • Velixo NX
  • Sage Intacct
  • Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Acumatica


  • Overview
  • Cause
  • Resolution


After entering a Velixo function, Excel displays the function in the cell, rather than the results of that function:


When the cell is formatted as Text, Excel will display whatever is typed in the cell - but will not evaluate it as a function or formula:



To fix this:

1. First, format the cell as General:

❗ At this point, refreshing the report will not yet help - the content of the cell is still displayed as text.

2. In order to get Excel to recognize that the content of the cell is a function (and not just text), we need to enter the formula edit mode (by double-clicking the cell, or selecting it end putting focus into the formula bar), and then press Enter:

  (this can be done within the cell - as shown - or in the formula bar above it)

3. Excel will then recognize the function and call on Velixo to evaluate the results:

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