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

Created by Damien Zwillinger, Modified on Wed, 13 Sep 2023 at 04:31 PM by Harry Lewis


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




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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article