Overview

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

na1.png

Explanation

When you first enter a Velixo function, Velixo Report 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 Reports displays that #N/A to let you know that the data is not yet available.

Velixo Reports 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:

na2.png

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

Did this answer your question?