Lost a whole day's work despite Autosave and OneDrive/Sharepoint

I'm at a loss for words. I'm working on a thesis I'm using an excel sheet in a shared onedrive/sharepoint folder with my supervisor, though I'm working on the excel sheet in the app with autosave on and everything, rather than directly in the browser. This morning, as I began working on the excel sheet, the window crashed, and when it restarted again I just clicked away the massive window with recovery files (because this has happened many times, and it's never reverted any data before, I'm working via the cloud, and the window is massive and annoying). Only then did I realize the version I had up was missing an entire full-day's work. I went into the onedrive/sharepoint in my web browser and went into the change history, and that too was missing the whole of yesterday. I went into %appdata% but could find no recovery file, probably because I dismissed them.

How did this happen, and is there any way to recover the lost data, like some recycle bin for the recovery file or something? I was logged in to the correct user and everything with no error messages yesterday, green checkmark on autosave etc.