Dann Albright July 14, 2017 4 minutes. How to Recover Any Unsaved or Overwritten Microsoft Excel Files. If you’ve been backing up your data, though, you might be able to get you Excel document. Recovering Excel Files in macOS. Recovering your unsaved or overwritten Excel files is a bit different on a Mac.
Need to recover an “unsaved” Excel file from your hard drive? Hoping it was saved by your “Autosave” feature? If you haven’t done anything else to the file yet, it should still be there waiting for you. My Scenario: The Unsaved Excel File I downloaded an Excel spreadsheet from my bank, saving it to my computer only once, during the initial download. After working on it for hours and failing to manually save it again, I accidentally clicked “ Don’t Save” when closing the file to log off for the night. I panicked and immediately reopened the file to see if the little “recover” message would be there at the top like it is when your computer crashes and you’re working on an Office document.
All I had was the original, unmodified file staring me in the face. I didn’t try to make any changes at all to my file at that point. I just closed it right away. The next time I logged onto the computer, I ventured to Google to see if I could find a fix for my Friday flub. Thankfully, I was able to! Note: In my case, I had an original version of the file that I’d saved to my hard drive.
Important File Recovery Prerequisites: Because I type 100+ WPM and can add a LOT of data to a file quickly, I have my Excel AutoRecover set to save every 1 minute. Open the original version of the file. It won’t yet show your latest changes.
While viewing that open file, go to the “File” tab in Excel. (I use Microsoft Excel 2010. Your interface may look different and instructions may differ slightly from the below.) 3. Look under the last heading, “Versions,” and click “Manage Versions.” 4. You should see a message that says, “ Recent version from 6:11PM (or whenever) when I didn’t save my file.” If so, click on it and see if that’s the version you need. If not, continue to 5.
Click “Recover Unsaved Workbooks.” Important: If you don’t FIRST open your file, you won’t be able to manage any versions of it (because you haven’t opened a file to manage versions of). If, however, you have opened your file and still don’t see any unsaved versions maybe your Excel isn’t set to save your files in a short enough interval.;( In that case, try by ExcelEasy. They helped me retrieve the latest version of my unsaved Excel file. The manual might also be useful in preventing these types of catastrophes in the future! — If this article helped you, or if you used another method to retrieve your unsaved Excel document, leave a comment to let us know.:.
Welcome to the forums! Perhaps - if you launch Excel (the application itself, not the original document) it may generate a Recovered Document file which hopefully will contain your data. This depends on your preferences settings in Excel, how close to the time you shut down you made the changes, and how you shut down. If you shut down 'properly' and were presented with a dialog box asking if you wanted to save the file, and you clicked Don't Save, you are out of luck. You can set the autosave preferences in Excel (or any Office app) in Preferences Save, check the box for Save Autorecover Info and set a time (the default for this is checked, with a 10 minute interval). Hope this helps.
Welcome to the forums! Perhaps - if you launch Excel (the application itself, not the original document) it may generate a Recovered Document file which hopefully will contain your data. This depends on your preferences settings in Excel, how close to the time you shut down you made the changes, and how you shut down. If you shut down 'properly' and were presented with a dialog box asking if you wanted to save the file, and you clicked Don't Save, you are out of luck. You can set the autosave preferences in Excel (or any Office app) in Preferences Save, check the box for Save Autorecover Info and set a time (the default for this is checked, with a 10 minute interval). Hope this helps.
Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.