I was working on a new workbook for about 30 minutes. I needed to pick up some additional data from another file, so I went to my file explorer and did a search for the file, and when it came up in my search results, I double clicked to open it.

To my surprise, Excel closed my current workbook without asking to save it (I know I should have saved it, but you know how it goes). The second workbook opened, and when I started looking for my autosaved workbooks to find the lost data, there's nothing!

My preferences are set to autosave every 10 minutes, so there should be something, right? I did find some files in that folder from earlier today, but nothing from the file I just lost.

This is the second time this has happened since changing to Office365, and it's a little annoying - although last time I just lost changes to a file, and not the whole thing.

Any idea what's going on?

Hi,
We have definitely heard your frustration, and we're thinking about ways to help you recover the data. Please go to File/Option/Save path and make sure the Keep the last autosaved version if I close without saving check box is selected. If this option is no selected, the data might be lost.

Then, please follow this article and try the methods:

https://www.ablebits.com/office-addins-blog/2014/05/26/recover-unsaved-excel-file/

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support