Forum Discussion
Issues with Excel and SharePoint Online
I have a customer that had a really nasty issue! Opened the Excel spreadsheet from Office 365 SharePoint team site, choose to edit in native Excel. Working some 9 hours regularly saving the file, Excel confirming save was ok. SharePoint records these saves as new versions but no data in the file has been saved… 9 hours of work lost and an extremely frustrated customer. Apparently, this is not the first time this happens. Anyone else having experience of issues like this?
Customer is running win 7 and one of the later builds of Office 2016. Workbook is about 5 MB in size…
Hi
I'm sorry to hear about that news...
I'm sure that it's been a long time since this happened.
But in order to prevent this issue from happening in the future, I would suggest:
1.set an alert on the document library (this way we can see who, when and what happened to which document)
2. as well, run audit log search from Security & Compliance Center , add in the search query the affected URL
If user goes to Excel and click on File-Open->he doesn't see the other version of the file (the latest modified file).
Did the user checked versioning for the affected excel file?
Have the same issue, did you get an answer?
No :(
Strange indeed. I'd suggest you to look in the Admin Recycle Bin: https://_______.sharepoint.com/sites/________/_layouts/15/adminrecyclebin.aspx?view=5
Edit: few similar issues happened to my tenants with Excel too. Please review my first point and also, check in your Documents librairy if you didn't get a copy of you file (i.e. filename (2).xlsx) or filename - Editable.xlsx
- Thank you for the suggestions Yoav, unfortunately nothing was found in the admin recycle bin and no copies of the file in the library.
- Wow that's bad. I haven't seen that at all.
Did they have the library synchronised to their local machine using the next gen sync client for OneDrive?
Perhaps you could do that so it is saving "locally" and then pushing it up to SharePoint.- Strange issue to my knowledge...Office integration in SharePoint works really well and when problems happen is normally due to user errors
