Functions appear as text and do not refresh

Applies to:

• Velixo Classic

• Velixo NX

• Sage Intacct

• Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Acumatica

Overview

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

Cause

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:

Resolution

To fix this:

1. First, format the cell as General:

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: