Functions appear as text and do not refresh

Overview

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

Excel cell displaying a Velixo function as plain text instead of calculating and showing the result

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:

Excel Number Format dropdown showing Text selected, which prevents function evaluation in the cell

Resolution

To fix this:

1. First, format the cell as General:

Excel Number Format dropdown showing General selected to change the cell format from Text back to 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:

Excel formula bar showing a Velixo function in cell edit mode ready to press Enter to trigger evaluation — (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:

Excel cell now showing the Velixo function result after re-entering the formula with General number format