Ignore an area for the Formulas to Review panel

Overview

During a report refresh, when Velixo NX encounters a potential issue, the cell and function involved are displayed in the Formulas to Review section of the Velixo NX side panel:

Velixo NX side panel showing a formula flagged in the Formulas to Review section after a report refresh


There are times when certain messages are expected, and you may not want to see the side panel notification.

This functionality is available in Velixo NX version 2024.6 and higher

Ignoring an area of your report

You can configure your report so that Velixo will ignore any issues in a particular area.

Step 1

Select the area for which you do not want to see the notifications:

Excel worksheet with a cell range selected to be excluded from Velixo NX Formulas to Review notifications

Step 2

From Excel's Formulas ribbon, select Define Name:

Excel Formulas ribbon with the Define Name option highlighted


Step 3

Within the New Name dialog...

  • In the Name field, enter VelixoSuppressErrors

  • In the Scope field, enter the name of the worksheet

Excel New Name dialog with VelixoSuppressErrors in the Name field and a worksheet selected as the scope


Click OK

Results

Now, when the report is Refreshed, any potential issues detected within that area will not appear in the Formulas to Review notification area:

Velixo NX side panel after applying VelixoSuppressErrors, showing no Formulas to Review notifications for the suppressed area