Error: #N/A displays first when entering a Velixo function

Overview

When first entering a Velixo function into a worksheet, #N/A appears and it takes a while for data to appear.

 

Explanation

When you first enter a Velixo function, the Velixo add-in sends a query to your data connection to retrieve the specific data you have requested.  Sometimes the amount of data involved can be quite large and take time to transfer.  Until the data has been fully transferred to Excel, Velixo displays that #N/A to let you know that the data is not yet available.

Velixo also displays a status update at the bottom of the Excel window to let you know how much data has been transferred from your data connection:

As the data is retrieved, it is cached (stored for future use) so that the next time you access that data, Velixo can get it from the much-faster cache rather than having to wait for the information be returned from your data connection.