#NAME? displays for all Velixo NX functions

Created by Harry Lewis, Modified on Mon, 17 Jun 2024 at 06:31 PM by Harry Lewis

Applies to:

  • Velixo NX


TABLE OF CONTENTS


Overview

When opening a workbook, all cells containing or referencing Velixo NX functions display Excel's #NAME? error:


 

If performing a Full Refresh of your report...


... does not resolve the issue, proceed with the troubleshooting techniques below.



Troubleshooting Techniques

Let's ensure that there is not an issue with the specific workbook.

  1. Close all Excel windows
  2. Reopen Excel
  3. Create a NEW, blank Excel workbook
  4. Click the Velixo button in the Velixo NX section of Excel's Home ribbon
  5. In any cell, type:  =SI.


If a list of Velixo NX functions is displayed...



...Excel *is* able to communicate with the Velixo NX add-in. Please contact Velixo Technical Support for help with your original workbook.




If, however, no list of functions is displayed...



... proceed with the resolution steps below.

 


Resolution


Step 1 - Within Excel, go the File ribbon and select Options




Step 2 - From the Excel Options screen, select Trust Center and then click the Trust Center Settings... button


  

Step 3 - From the Trust Center screen, select Trusted Add-in Catalogs and then click the option Next time Office starts, clear all previously-started web add-ins cache.



Step 4 - Click OK



Step 5 - Excel will let you know that your settings have been saved.  Click OK again


Step 6 - Click OK to exit the Excel Options screen.



Restart Excel


You can now close and restart Excel for the setting change to take effect.


Excel should now be able to access the Velixo NX add-in.

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