Excel Sync Troubleshooting
When an Excel Sync revision fails to load the status will be listed as Invalid, and the error causing it to first fail will be indicated in the Errors column.
Given that the sync stops processing once the first error is found, you may find that once the error is fixed and the file is re-processed another error will be presented.
Common Errors
| Error | Description | Resolution |
| Invalid transaction ID on row "row_number" | The transaction was removed from the system after the output file was originally created, so the system cannot find the transaction to update OR the transaction ID has been altered. | Remove the entire row listed in the error message. |
| Invalid transaction kind in row "row_number" | Typically, the row number listed will be the first empty row at the bottom of the sheet. Excel has masked values within the row's cells that shows up in the CSV conversion. | Select and delete all empty rows below your data. |
| Invalid column "column_name" in CSV file | The sync process looks for the columns in the exact order that the current output file produces. If columns are reordered, added, or deleted this error will be shown. The column name listed is the first column that is out of order. | Export a fresh file from Valid8 and compare those columns to your existing sheet. |
| Vis Category "category_name" has 100+ unique labels which exceeds the maximum number of allowed labels (100) | 100 case-sensitive, unique labels is the allowed limit in each vis category. This includes any previously created labels as well as the new labels you are currently importing via Excel Sync. | Consolidate labels in your Excel Sync file or remove unused labels that already exist in the engagement. |
| Column naming does not meet the standard; please resolve or reach out to support. | VisCategory columns or Custom Columns have been reordered from their original positions OR there are duplicate column headers | Return columns to their original positions and remove any duplicate column headers. |