导航菜单

你一定用的到!快速恢复未保存的excel文件

Too many small partners ask questions, Excel files are closed without saving, how to recover data?

If you search Baidu, you will find a common method:

File - Info - Manage Workbook - Restore unsaved workbook - Find backup file - Restore

edf51265c81e42ca8cea92914087b737

Is this feature really useful? Some people say that someone can say no. Today, Xiaobian will test it.

Step 1: The premise of recovery is that Excel should be saved automatically. To facilitate testing, set the autosave interval to 1 minute.

23a09f9009604cd98830402e78fcdf1a

Step 2: Open the test file for a simple edit

3e5d28e0e1c940e8a98772e683ff7f62

After 1 minute. manually close and not save.

f5e03432cc854f9384959b085bba0800

Test recovery function

aca1d79dcb13492fbcc2a7502a0d5a94

File - Info - Manage Workbook - Restore unsaved workbook - Find backup file - Restore

As a result. there are no gods in the backup folder. Excel, you can't lie like this!

It seems that I heard a classmate’s disappointment and said: Today’s tutorial is to see how you failed. Oh, of course not. It is not impossible to recover, but our method is wrong.

The right thing to do:

File - Excel file - Save the tab, copy the automatically saved path, paste it into the folder address bar and press Enter to open it. The original recovered file is hidden here (Excel file name + folder name composed of numeric strings). Double-click to open the backed up file, which shows the format before the unsaved. Click the "Restore" button and the file will be successfully restored!

xxe1936f3acab34211925f7be148861edb

小编说:这种恢复功能不是100%有效。但测试可以成功恢复多次,性格太好了?嘿嘿.EXCEL精英培训。