Description
In this video I'll show you how to recover unsaved Excel workbooks. If Excel closed before you saved your work, whether you clicked the wrong button or your computer crashed, there's a good chance you can still get it back.
Timestamps:
Introduction: 0:00
Recover Unsaved Workbooks: 0:16
Turn On AutoRecover: 1:33
Use AutoSave with OneDrive: 2:10
Conclusion: 2:20
Check out my website for other great tutorials about all kinds of technology: https://maxdalton.how/
Support this channel by becoming a member: https://www.youtube.com/channel/UCBbDWMccTJCL0WmbMHNLZIw/join
#excel #microsoftexcel #exceltutorial #techtips #tutorial
Video Transcript:
Step 1. Open Microsoft Excel, and then click "File" in the top left corner of the screen.
Step 2. Click "Info" in the menu on the left side of the screen.
Step 3. Click "Manage Workbook," and then click "Recover Unsaved Workbooks." A window opens showing the folder where Excel keeps copies of unsaved workbooks.
You can also get to this folder by clicking "Open" in the File menu, and then clicking "Recover Unsaved Workbooks" below your list of recent workbooks.
Step 4. Click the workbook you want to recover, and then click "Open." Unsaved workbooks have names like "Book1" followed by a long number, so check the date modified to find the right one. The workbook opens, and a bar at the top of the screen lets you know it's a recovered unsaved file. For this example, I'm recovering a new releases order sheet for a comic book shop.
Step 5. Click "Save As" in the bar at the top of the screen, choose where you want to save the workbook, and then click "Save." Make sure you do this right away, because Excel only keeps these unsaved copies for a few days.
To make sure this works next time, click "File," click "Options," and then click "Save" in the menu on the left side of the window. Make sure the "Save AutoRecover information every" box is checked, set it to a short time like 5 minutes, and make sure the "Keep the last AutoRecovered version if I close without saving" box is checked. Then click "OK."
If Excel crashes, it usually shows a Document Recovery pane on the left side of the screen the next time you open it, where you can click a recovered file to open it. And if you save your workbooks to OneDrive, turn on the "AutoSave" toggle in the top left corner of the Excel window, so your changes are saved as you go.