All Collections
Helpful Info and Troubleshooting
Reporting Topics
Report displays #N/A until each cell is edited
Report displays #N/A until each cell is edited
Selecting the cell and pressing Enter fills in the data one function at a time
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago

Overview

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:

Cause

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.

Resolution

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.

Did this answer your question?