Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving

This can be said to be a problem that many users encounter, that is to close the text file, Office has just worked but forgot to save - Save again. Or in case of a sudden power outage, the computer has a blue screen error, hangs up ... all can happen at any time. So, if you want to find out what Excel, Word or PowerPoint files have not saved, what should you do?

This can be said to be a problem that many users encounter, that is to close the text file, Office has just worked but forgot to save - Save again. Or in case of a sudden power outage, the computer has a blue screen error, hangs up . all can happen at any time. So, if you want to find out what Excel, Word or PowerPoint files have not saved, what should you do? Please read the article below of TipsMake.com offline!

  1. Summary of expensive shortcuts in Microsoft Excel
  2. 10 ways to recover corrupted Excel files

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 1Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 1

Recovering documents has not been saved yet

  1. 1. Get back the Excel 2010, 2016 files before saving on Windows
    1. 1.1 Retrieve Excel 2016 file before saving
    2. 1.2. Retrieve Excel 2010 unsaved
  2. 2. Restore unsaved Excel file on macOS
  3. 3. How to recover unsaved Microsoft Word 2016 documents in seconds
    1. How to recover unsaved documents
  4. How to use the AutoRecover feature
  5. How to customize the AutoRecover feature

1. Get back the Excel 2010, 2016 files before saving on Windows

1.1 Retrieve Excel 2016 file before saving

Method 1: Use the Excel 2016 application on your device

To restore Excel files that were closed unexpectedly without saving, follow these steps:

Step 1: Go to File> Open> Recent

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 2Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 2

Step 2: Drag down the last screen> click Recover Unsaved Workbooks

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 3Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 3

Step 3: You will see the files saved automatically in this section:

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 4Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 4

Just open the file you need, then save it.

Method 2: Restore Excel file from OneDrive

Of course, this is only available when you back up or sync document files on your computer to OneDrive.

OneDrive keeps the history of a version that you can browse and restore from whenever you want. You can save them to a folder, such as Documents. Easiest way to complete this process through the OneDrive browser interface.

First, visit the onedrive.live.com page.

Browse to the document file you need to restore, right-click it, select Version history.

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 5Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 5

You should now see a list of versions that OneDrive has stored. You can even preview each version. Find the correct version and select Restore / Restore to overwrite the current version of the document or Download / Download to download a copy of that version.

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 6Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 6

1.2. Retrieve Excel 2010 unsaved

Did you know that Microsoft has "secretly" equipped a great feature for Office office suite, helping users to REMOVER THE UNLIMITED DOCUMENTS . And to use this feature, you need to follow the following sequence:

  1. Your Microsoft Office must have AutoSave and AutoRecover in active status.
  2. Open the Office application you need to use.
  3. Select the File tab.
  4. Select Next.
  5. With Word 2010, select Recover Unsaved Documents. In Excel 2010, select Recover Unsaved Workbooks and PowerPoint 2010 is Recover Unsaved Presentations:

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 7Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 7

With Microsoft Office Word 2010

When using this feature, the text file's Draft - Draft folder will be displayed. Please find the right file to use and select Open , when you find the data file you need, Save As to your working directory on the computer. Note that the draft file storage folder has different addresses, depending on the operating system:

  1. On Windows Vista / 7/8 : C: UsersUser_NameAppDataLocalMicrosoftOfficeUnsavedFiles
  2. Windows XP: C: Documents and SettingsUser_NameLocal SettingsApplication DataMicrosoft OfficeUnsavedFiles

A further note is that you absolutely should not change the path to save this draft file of Microsoft Office, and normally these draft files will be saved within a maximum of 4 days from the initialization time.

2. Restore unsaved Excel file on macOS

To restore Excel files that have not been saved, overwritten on macOS, you can also do it the same way as on Windows, ie get back files through OneDrive. In addition, there is another way to get Excel file on Mac as follows:

Open Finder > Macintosh HD. If you don't see Macintosh HD (or another name for your hard drive), go to Finder> Preferences and select Hard disk in Show these items in sidebar.

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 8Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 8

Normally, the path will be as follows: Users> [ten_tai_khoan]> Library> Application Support> Microsoft> Office> Office 2011 AutoRecovery

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 9Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 9

If you do not see the Library in your user directory, you will need to display the hidden file. First, enter the following command in the terminal:

defaults write com.apple.finder AppleShowAllFiles YES

Then, Option + right- click on the Finder icon and select Relaunch .

You can use the terminal to make this process easier by typing the following command to open the appropriate folder:

 open /Users/[ten_tai_khoan]/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery 

Depending on the version of Office, the target messages may differ. For example, Excel 2016 saves files in ~ / Library / Containers / com.microsoft.Excel / Data / Library / Preferences / AutoRecovery /

If you are having problems finding AutoRecovery files, try searching for your version of Office to see where they are stored. Once you've found the file you need, just double click to open it and save it immediately.

Note that Excel only keeps this AutoRecovery file for a limited time, so it's best to practice pressing Ctrl + S as soon as you stop typing.

3. How to recover unsaved Microsoft Word 2016 documents in seconds

Have you ever accidentally quit a Word 2016 document without saving? It was really a disaster. But with Word, maybe not all data is lost. The article will show you how to recover data quickly.

How to recover unsaved documents

The situation will be like this. You are using your Word document. You press the close button. A window pops up, asking if you want to save your changes. By mistake, you click Don't Save. It is so awful!

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 10Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 10

First, open Word. Navigate to File> Open . Here you will see a list of all your recent documents. At the bottom, click Recover Unsaved Documents . This will open a folder containing all your unsaved documents in the last 4 days.

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 11Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 11

Just double click on the file to open it. Under the ribbon, you will see the message that This is a recovered file that is temporarily stored on your compute r. Click Save As and select somewhere on your system to permanently store the file. After selecting, click Save.

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 12Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 12

If you are unable to perform this step and have trouble opening the file, it may be corrupted. Click your file from the list and click the drop-down arrow next to Open. Here, you can select Open and Repair, this will automatically fix any problems.

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 13Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 13

Also, if you want to navigate to the folder of documents that have not been saved manually, press the Windows + R key to open Run. Enter the following information and click OK:

 C:Users%USERNAME%AppDataLocalMicrosoftOfficeUnsavedFiles 

In addition, you can refer to the article: How to recover a corrupted or lost Word 2016 document to learn more details.

How to use the AutoRecover feature

AutoRecover is a useful Office feature when Word has an interruption, such as a system crash or a power outage. However, it should be noted that it cannot replace the usual method of saving text.

To use AutoRecover, launch Word and you will see the Document Recovery control panel . This will list all available files with their title and timestamp.

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 14Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 14

You can click on each file to view its contents. If there is anything you want to save, click the drop-down arrow next to the file and click Save As . Here you can choose somewhere fixed to save your file.

Word can only provide these once-restored documents, so don't delay if there is something you want to save.

How to customize the AutoRecover feature

AutoRecover must be turned on by default, but check it carefully and see how to tweak this feature. Open Word and go to File> Options> Save . If this feature is not enabled, select Save AutoRecover information every X minutes .

You may want to adjust the length of time the files are saved automatically. Such as 10 minutes for example.

Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 15Recovering unsaved Word files, retrieving Word, Excel and PowerPoint files before saving Picture 15

Also, select Keep last AutoRecovered version if I close without saving .

Below this, you will find the AutoRecover file location. If you want to change it, click Browse ., go to the directory path and click OK. However, the default directory path may be fine.

More reference: Set AutoSave feature in Office 2016

Hopefully, this guide has helped you recover the Word 2016 file you thought was gone forever.

Remember, you should regularly save the document you are working on.

Does this advice help you get back the file you think you lost? Do you have any other advice you want to share to recover Word 2016 files? Please share your comments in the comment section below!

Good luck!

See more:

  1. How to recover data using Easeus Data Recovery Wizard
  2. Effective data recovery software on computers
  3. Recover effective data with 'Recover My Files'
4.3 ★ | 4 Vote