Sometimes, either because of an oversight, an error of the system or connection problems, we can end up losing the Excel file in which we were working. This situation can be very frustrating, since it seems that all progress has vanished (or at least we think). This is where it becomes important to make frequent saves while we work.

Many users believe that an unguided Excel file is impossible to recover , but that is not true . In this article we will show you several effective ways to recover those files you thought was missing. In addition, we will give you some practical tips to prevent future information losses.

Unchanged file search engine

The first resource to which you can go, and the most common, is the integrated tool for unchanged files that Excel has. It is possible that the file is still in the same location where you usually save it. Although all lost documents do not always appear, this method is a good starting point.

Follow these steps: first, open a blank book and go to the " Archive " tab. There, access the " information " option. Then, click " Manage book " and finally select " Recover unaddated books ." An explorer window will open where you can search and select the unavailable temporary files.

OneDrive backup

This method is ideal if you use OneDrive as your usual storage space, since this service maintains a backup copy of the most recent version of your files . Thanks to this function, you can recover documents you thought lost.

To do so, enter OneDrive , locate your file and right click on it . In the menu that appears, select ? Version history ?. You will see a list of saved versions. Choose the one you need, click on the three points and download it to restore it.

Check the automatic save

Microsoft Office includes an automatic saving function that can be saved at times like this. This tool allows you to recover files even if you never saved them manually .

To access it, go to the start tab and look for the option " See recovered documents ." A list will be displayed with the files that were opened recently and that were not stored correctly. You just have to click on what you need. Keep in mind that, once recovered, you must save it as a normal Excel file , since the temporary copy will be deleted when closing the program.

Excel documents recovery

This function allows you to easily recover unchanged changes. To use it, open Excel and look for the " recovered " label. Click " Show recovered files ." A panel will appear with the title " Document recovery ", which will show the available temporary files. You just have to open the desired document and press the save button to keep it permanently.

Search in the computer cache

This method can be a bit more complex, but it is useful if the previous ones do not work. In Windows, the system keeps temporary copies of the Excel files in the cache folder . You can access it from the route: c/users/tuname/appdata/local/temp .

With this folder, temporary files are stored, but finding yours can be difficult. You will have to check the files with extension .TMP , which can take time. Therefore, we recommend using this resource only if you have already tried all the other options.

Other tips

We suggest you link your OneDrive account with Excel . Thus, even if you do not keep manually, your progress will be automatically supported in the cloud when closing the program. Although this function is useful, it does not replace the habit of keeping manually. To link your account, open Excel, go to " options ", then " counts " in the left menu and select " connected services ." Make sure Onedrive is active; If not, add it.

Another good practice is to adjust the frequency of automatic save . By default, Excel keeps every 10 minutes. If you work with important documents or spend a lot of time in the program, reduce this interval. Go to " options " → " save " and modify the time in " save self -refereement information ."

As you can see, recovering an unbalanced file does not have to be a desperate task. With these tools and tips, you can recover your work easily. If you are interested in even more protect your documents, here are an article on how to protect your excel files with password that could be useful.

The above is the detailed content of How to recover unchanged files in Excel. For more information, please follow other related articles on the PHP Chinese website!