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