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. |
| 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. |