Lost several day's worth of work in an Excel file?

Anonymous
2023-09-11T07:06:01+00:00

I opened, edited and saved a file in Excel several times last week without issue. This included adding a new sheet, then editing it over several days.

The file is in my work account's OneDrive.

Today I opened that same file to find that all my recent work (the whole sheet) has vanished; it seems to now be a version from 2 months ago, according to the last saved date. So naturally there is nothing in version history, and I cannot find any way to check for unsaved recent changes, but in any case, it was saved and opened again several times last week without issue, so I wouldn't expect unsaved recent changes to contain anything except perhaps the most recent edit.

How is this even possible!! Is there any way to recover the many hours of work I have lost?

My device is Windows 11, I have a personal account and a work account on the machine (and I have checked; it wasn't saved in my personal OneDrive).

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

56 answers

Sort by: Most helpful
  1. Anonymous
    2025-03-07T05:23:11+00:00

    Happened to me just nowwwwww. Is there any way to recover the recent edits?

    UPDATE: Problem fixed. Followed @guestasaurus instructions. Found a file with the same document name in the TempBackUpFile folder of Excel inside C: drive.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2025-01-02T17:55:17+00:00

    I officially love you! I had the same issue as everyone else. A file that I work on daily and save daily showed I hadn't touched it in over a month. All the data gone. This worked!!!!! Thank you!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2024-08-23T14:55:16+00:00

    Seems to be a frequent and recurring issue. Not the first time I've had this happen in excel and had to start all over again. I frequently save to PC and OneDrive to find the file is completely missing or a version from months before. Yes, I have tried all the previously mentioned steps, recovery on, check caches and temp ect. Not impressed. Trying to steer people away and use SPSS or other data management programs.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2024-05-21T03:03:30+00:00

    Hi, my spreadsheet WAS SAVED to OneDrive. I had auto save and everything on it. I am that age where you had to save everything when you were little otherwise you’d lose it. It’s deeply ingrained within me. We would have a thunderstorm and the power would go out and you would lose everything, so now I save it all. So I don’t know what happened. And they aren’t providing answers

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. Anonymous
    2024-05-21T02:21:36+00:00

    The exact same thing happened with me. I have always used excel for my budgeting and when I opened it today it reverted to a sheet from January, lost everything up until now (May). No ability to recover as it was saved to my computer not onedrive.. please tell me this is a bug :((

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments