+4 votes
75 views
in Office by (242k points)
reopened
How to recover an unsaved Excel 2019 file

1 Answer

+5 votes
by (1.6m points)
edited
 
Best answer

1. Activate AutoRecover in Excel 2019
2. Recover unsaved Excel 2019 files
3 . Automatically recover Excel 2019 files
4 . Excel 2019 file backup

Microsoft Excel has been developed to give us a set of practical functions for the work of various types of data, but a problem that we commonly do is to concentrate on the information we are recording and not take the precaution of saving the data and situations such as outages can happen. of power, unexpected shutdowns of Excel, crashes in the operating system, etc,

 

This will make us lose our work and if it becomes delicate or quite we can simply lose patience, but all is not lost since Excel integrates an option to recover files not saved in the application and in getFastAnswer we will see the step by step to access these..

 

 

To stay up to date, remember to subscribe to our YouTube channel!   SUBSCRIBE

 

 


1. Activate AutoRecover in Excel 2019

 

Step 1

The first thing we must do is configure automatic saving in Excel 2019, for this we open Excel and go to the "File - Options" menu:

 

image

 

Step 2

In the options window we will go to the "Save" section and there we activate (or validate that it is) the "Save auto-recovery information every" box, then we set the desired time, in minutes:

 

image

 

getFastAnswer advises you to leave the minimum in time, that is, set 1 minute for the automatic saving of Excel 2019.

 

 


2. Recover unsaved Excel 2019 files

 

Step 1

For this, we open Excel and go to the "File - Open" menu:

 

image

 

Step 2

At the bottom we click on the "Recover unsaved books" button, this will open the window where the books or worksheets are temporarily saved with the automatic saving method, in Windows 10 by default it is on the path:
 C: \ Users \ user \ AppData \ Local \ Microsoft \ Office \ UnsavedFiles 
image

 

Step 3

We select the Excel file and click Open to access its content:

 

image

 

Step 4

At the top we click on "Save as" and now we store it safely:

 

image

 


3 . Automatically recover Excel 2019 files

 

Step 1

This is the most popular built-in function of Excel 2019 to recover a file by sudden closures, when Excel closes, we open Excel and create a new file, the self-recovered file will be available on the left side:

 

image

 

Step 2

If it is the required file, we click on the file to open it, if not, we click Close to hide this functionality, when we click we will open the file in question:

 

image

 

 


4 . Excel 2019 file backup

 

Step 1

Finally we have an extra security and backup mechanism such as creating a backup copy when saving the file, for its use, we go to the "File - Save as" menu:

 

image

 

 

Step 2

In the Save as window we click on "Tools" and in the list we select "General options":

 

image

 

 

Step 3

Now, in the pop-up window, check the "Always create a backup" box. Apply the changes and save the file.

 

 

image

 

 

In this way it is possible to recover unsaved files in Excel 2019..

 

 


...