Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Possible to recover excel file if it's accidentally saved over on another computer?

Copper Contributor

I have a multi-use sheet that only I work on that autosaves and sometimes I use different computers. I made the mistake of leaving it open on two separate computers. On computer one, I created a whole new page and put hours of work into it. Saved and closed. I go to it later on computer two and the sheet is already open on it from a past visit. Before it had updated to show all the work I'd done on computer one, it autosaved with what was on computer two and erased in the cloud all memory of me doing anything. I shut it down and ran back to computer one and it saved over my new work. I realize this is probably written on some Excel ten commandments somewhere, but please is there any way to recover past cloud network file work even after you have saved and exited out? Thank you

2 Replies
I'll also not that I googled this and followed the "view history" protocol which only has versions before the work I did and after it accidentally saved over. I'm trying to see if there is a more advanced way to drill down into more specific increments of history to see if my important work is hiding somewhere. Thank you

@ThanasiManoli 

I understand your situation and how frustrating it must be to lose that much work. Recovering the accidentally overwritten Excel file might be possible, but the chances depend on which methods you can try:

Built-in options:

  1. Previous Versions:

    • If you're using Windows with File History enabled, right-click the overwritten file and go to "Properties" > "Previous Versions". If available, you can restore an older version from before you saved on computer two.
    • Check if OneDrive or your cloud storage has version history enabled. Some services like Google Drive and Dropbox offer similar features.
  2. AutoRecover in Excel:

    • Open Excel and go to "File" > "Info" > "Manage Workbook". Click "Recover Unsaved Workbooks" and see if your new work was automatically stored there.

Data Recovery Software:

  • If the methods above don't work, you can try data recovery software. However, there's no guarantee they'll succeed, and they can be costly.

Other considerations:

  • Did you have any temporary files stored locally on either computer after working on the new page? They might contain fragments of your work.
  • Was the file stored on a local server or network drive? If so, there might be backup versions available depending on the system's configuration.

Prevention for future:

  • Always save your work with unique names or timestamps while working on different computers.
  • Consider enabling version history for your cloud storage.
  • Utilize cloud platforms that offer real-time collaboration features to avoid conflicts.

Unfortunately, there's no single definitive answer to recovering your lost work. It depends on the specific circumstances and available options. But hopefully, exploring these avenues might offer a chance to retrieve at least some part of your efforts.