Microsoft Excel has several features designed to help you recover unsaved versions of spreadsheets and prevent data loss. If Excel closes before you save a file, you should see a Document Recovery tab ...

If OneDrive is overwriting files with older versions, set the date and time correctly, reset OneDrive, Pause sync temporarily ...