Forum Discussion
Changes lost Excel / O365 / Sharepoint Online
Hi,
We worked in a project on an Excel sheet. We opened the document in Excel from the online. We saved the changes.
However the changes are lost. We tried:
- microsoft support tool
- the version history of the online document
- the version history of the offline document (Onedrive for Business)
- the unsaved files
But.... we cannot find it. One the changes of another user are saved.
Any ideas on how to recover the lost changes? We worked on the documnet with a group for a whole day, so it is really important to recover
Thx for your help.
4 Replies
- We have the same issues for excel and word documents.
Randomly, all changes are lost.
SharePoint 2016 is installed on premise.
Check In Check Out enable,
Versionning by default
Only One user is working on these documents...
No response from Microsoft support.
To be positive,
We should be happy to participate in this lottery, when our work is saved, and accept not to win every day. - From the list of places you checked, it looks like you have looked everywhere you could.
We're you co-authoring in the Excel doc concurrently, while someone else accessed the doc? Were you all using Excel in the web browser? A recent update to Office Pro Plus means you should be able to co-without concurrently, using Excel for desktop. The new version also switches to Auto-save sometimes, depending on where the saved document is stored. I would have expected you to find many versions of the document while you edited it with others.I asumed at least one person viewed / edited (apparently) edited the document. I was presenting the document and we discussed all the changes. In between I saved every now and then with Control-S. This version is not found in the version history. Maybe the temp file lost its connection to sharepoint or something like that. Another (Mac) user reported a similar problem.
I still hope to find a temp file with the changes.
It seems to me it's not reliable when you choose "Edit in Excel" (not online).
Everyone was using the web browser (as they all were external users).
The version we used: see attached.
We have the same issue. a single very important user worked on a word document by 'Editing in Word' and saved the changes multiple times. We have "forced check-out" on our library. During the multiple saves user confirmed in SharePoint library that it was showing that the saving did result in reflecting new time stamp etc while it is still checked out. The user then "X"ed out from MS-Word and it asked for regular messages to save the changes before closing and check-in. But after check-in the document version was back to where the user started working on and lost hours of work. We checked every where, 'in recent documents', 'download' folder etc, but we could not find our updates.
