Overview:
When working with Active Workpapers in Excel, you may encounter various sync errors indicating a mismatch between your local workbook and the version saved in Active Platform or delays in syncing with SharePoint. This article explains common sync error messages, the mechanics behind them, and how to resolve these issues.
Common Sync Error Scenarios:
Below are the most frequent sync error messages and guidance on how to resolve them.
1. Excel Workbook Sync Error (Version Mismatch)
Error Message Example:
“The Excel workbook you’re currently working on is a different version than the one synced with Active Platform. The changes in this workbook were last saved in Excel on [date], while Active Platform shows the last recorded changes for this binder occurred on [date].”
Cause:
This error occurs when there’s a mismatch between the version you’re working on in Excel and the version saved in Active Platform. This typically happens when:
There’s a delay in syncing changes.
Multiple users are working on the same binder without properly syncing their changes.
The system performs periodic checks to compare the version you're working on with the version saved in Active Platform. If no changes have been synced for just under 5 minutes, a check is triggered, but if SharePoint hasn’t updated the file in time, the error will display.
Steps to Resolve:
If you believe your version is the most up-to-date:
Click "Continue" to push your changes to Active Platform and save your version.If you are unsure or want to check the latest version first:
Click "Read-Only" to view the latest version of the binder in Active Platform without making any changes.
Tip:
To avoid this error, ensure AutoSave is enabled in Excel, as this automatically syncs your changes. Also, try to avoid long periods of inactivity before making edits to reduce the chances of triggering this sync check.
2. Excel Workbook Sync Error (AutoSave and SharePoint Sync Issue)
Error Message Example:
“We’ve noticed that your changes are not saving into Active SharePoint. Active SharePoint was last updated on [date and time]. Please ensure that auto-save is enabled and that you are connected to Microsoft Office correctly.”
Cause:
This error indicates that AutoSave is maybe disabled, and changes are not syncing to SharePoint. The system may have attempted a sync before SharePoint had fully updated with your most recent changes, leading to the error. This can happen when:
There are temporary network connectivity issues.
SharePoint experiences delays in updating your changes.
Steps to Resolve:
Check AutoSave:
Make sure AutoSave is enabled in Excel to ensure your changes are being saved automatically.Check your connection:
Ensure that your connection to Microsoft Office is stable and there are no network disruptions.Click "Save and Continue":
If you believe your changes are the most up-to-date, click "Save and Continue" to manually push them to Active SharePoint.Click "Continue Anyway":
If you want to continue working and let the system retry syncing in 5 minutes, click "Continue Anyway."
