Velixo Report stuck in constant #N/A state and not refreshing

Velixo Report stuck in constant #N/A state and not refreshing

Symptoms:
  1. Velixo workbooks are stuck in a constant state of not refreshing
  2. The user has attempted to clear the Local Cache
  3. The same issue doesn't occur with other users, suggesting it is workbook related.
  4. When clicking into the cell, and then clicking enter, the values appear
  5. You are using Velixo Classic ONLY
Troubleshooting Process

Potential Workaround 1:
  • Create a new worksheet in the same workbook
  • Cut and paste all cells from the old worksheet to the new one
  • Delete the old worksheet
Potential Workaround 2 (Advanced Users Only):
  1. Create a new Macro that is added to ThisWorkbook module.
  2. Place the below script within the sub, press F5 to launch and wait until complete
  3. Save the Workbook and discard the VBA Module
  1. Sub DeleteHiddenNames()
  2.     Dim nm As name
  3.     For Each nm In ActiveWorkbook.Names
  4.         If nm.Visible = False Then
  5.             If Left(nm.name, 3) <> "_xl" Then
  6.                 nm.Delete
  7.             End If
  8.         End If
  9.     Next nm
  10. End Sub



    • Related Articles

    • Updating a License for Velixo Reports

      Issue You have requested a new license or changed the license in any way, and it is not reflecting on the client site. Resolution 1. Open any functioning Velixo Report 2. Go to the Advanced Tab > Clear Local Cache 3. Do a Full Refresh 4. Go to the ...

    • Updating Velixo License

      Issue: You need to force update your Velixo license details after a change has been made to them. Resolution: Open Excel Go to the Velixo Tab / Accumatica Tab Click Advanced > Clear Cache Close down Excel and all instances Re-open Excel to initialize ...

    • SQLite Connection Error with Velixo

      Issue When trying to run or update Velixo on a workstation, you are getting a SQLite access error Symptoms You are prompted with the screenshot above when: Trying to reset the local cache Do a new install and refresh a worksheet Trying to add your ...

    • The Sage Intelligence Report Designer Add-In is not responding

      Products Sage 300 2016 Description When trying to add a New Layout in Sage Intelligence Report Designer reports, the below error appears. DESCRIPTION Cause The Visual Basic for Applications (VBA) components / .NET Programmability are not installed. ...

    • Velixo Report no longer working and NX Installation Requested from side panel

      Issue / Symptoms Your Velixo report has suddenly stopped working and it has been working previously. There may also be a case where it is asking you for permission to install a new Addin called Velixo NX. This will show up in the side panel. The ...