Error: #NAME? is displayed when report is shared with others

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 5:48 PM by Gabriel Michaud

Applies to:

  • Velixo NX
  • Velixo Classic
  • Every ERP


Description

Velixo reports can typically be opened for viewing by any Excel user (even those who do not have Velixo installed).

 

HOWEVER, if Velixo is not installed, as soon as a change is made to the workbook, Excel will recalculate and will display #NAME? in any cell containing a Velixo function.

 

Similarly, if a report includes any of Excel's volatile functions  [ such as =TODAY() ], Excel always recalculates the workbook as soon as it is opened (presenting the same #NAME? issue).

 

 

Solution

Sharable copies of your Velixo workbooks can easily be created to avoid this issue. Please see our article on Sharing Reports with non-Velixo Users.

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article