A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Welcome to Microsoft Q&A.
First of all, thank you sincerely for taking the time to report this issue in such a clear and detailed manner, and for attaching the supporting documentation. Your thorough explanation has been incredibly helpful in understanding the scope and impact of the problem.
From what you've described, this appears to be a critical issue affecting AutoSave and synchronization between Excel and SharePoint when using the Check Out feature. The fact that this behavior began with version 2509 of Microsoft 365 Apps and continues in 2510 suggests a potential regression or compatibility issue introduced in recent updates.
Given the severity and the potential for data loss, I recommend the following steps:
1. Report the Issue to Microsoft Support
Since this appears to be a version-specific issue, your Microsoft 365 administrator should open a support ticket via the Microsoft 365 Admin Center. The backend support team can:
- Analyze tenant-level logs.
- Investigate Excel sync and AutoSave behavior.
- Identify any service-side bugs or policy conflicts.
- Provide hotfixes or rollback guidance if applicable.
When submitting the ticket, please include:
- A detailed description (as you've provided here).
- The affected Office versions (2509, 2510).
- Screenshots or logs (from your attached report).
- Confirmation that the issue occurs across multiple users.
2. Temporary Workarounds to Minimize Impact
While awaiting a permanent fix, here are some practical steps to help reduce disruption:
- Rollback to Office version 2508, where the issue was not observed.
Guide: Change update channels or roll back Office versions
- Encourage users to save frequently, especially after Check Out.
Even with AutoSave enabled, manual saves can help preserve progress.
- Monitor AutoSave status: Ask users to keep an eye on the AutoSave toggle in Excel. If it turns off unexpectedly, save the file immediately to avoid data loss.
- Admin monitoring: IT admins should regularly check for locked files in SharePoint and assist users in unlocking or restoring versions when needed.
- Enable version history in SharePoint libraries to help recover lost work if needed.
Thank you again for your detailed report. I truly hope this issue is resolved soon so your team can return to a smooth and reliable workflow. If you run into any issues while trying the steps, or if something still doesn’t feel quite right, please don’t hesitate to reach out again. I’ll do my best to support you however I can.
Looking forward to hearing back from you with any updates or additional details.
Warm regards,
Liora
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.