123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computers >> View Article

How To Enable Autorecover To Get Deleted Spreadsheet Back In Excel

By Author: Aida Martin
Total Articles: 247
Comment this article

Don’t want to lose a document that you’ve created in hours or with collaboration? Losing a completely created spreadsheet is even worse than spending hours in making it. There are many things, which can land you into this trouble. You may lose your document because of system freeze, power outage, application crashes, etc.

Possibly no one wants to go through this pain. Microsoft understands the pain of losing a created file, that is why it offers a couple of ways to prevent this from happening. You can save the document in between simply, or use temporary backups, recovered files, as well as OneDrive backups to get your accidentally deleted files back in Office Excel. AutoRecover saves the document you’re working on automatically after a predefined (customizable) time. The feature is already present in the application, and you can activate it easily on your device.

Here is how to enable AutoRecover to get deleted spreadsheet back in Excel

Enabling AutoRecover in Microsoft Excel for Windows

However, the AutoRecover feature is enabled already in most of the Office app. This time gap may be a little long, depending on your needs. If you want your deleted spreadsheet back from where you’ve lost it, then you need to ensure that the AutoRecover is enabled in your Excel. You can do so by using the steps listed below.

1.   Open Microsoft Excel app in your system. You can directly open a workbook to launch the app.

2.   Then, open already created or a new document.

3.   After that, open the ‘File’ tab.

4.   And go to ‘Options.’ This opens the Options window in the opened document.

5.   Look for the ‘Save’ option under the left menu.

6.   Click on ‘Save.’ The Save settings for your Excel app will now appear on the right-hand side.

7.   Under Save workbooks heading, make sure the “Save AutoRecover info every [TIME DURATION] minute” option is checked. You’ll see the predefined (10 minutes) time under the box with an upward and downward button to customize it.

8.   Use the buttons of the TIME DURATION box to change and specify the minutes you want your document to save.

9.   You can also check other options under Save workbooks heading to use them as well for keeping your documents safe from accidentally deleting.

10.  After enabling Save workbooks settings, click on ‘OK’ to apply them in your app, and return to the sheet.

 Enabling AutoRecover in Microsoft Excel for Mac

The procedure for enabling AutoRecover in Excel is a bit different in Mac but simple.

1.   Open Microsoft Excel app on your Mac. You can directly open a workbook to launch the app.

2.   Then, open already created or a new document.

3.   Click on the ‘Excel’ tab at the top and select ‘Preferences.’ This will open the Excel Preferences dialog box on the screen.

4.   Click on the ‘Save’ option under the Share and Privacy (third) heading. The Save settings for your Excel app will now appear under the Save dialog box.

5.   Make sure the “Save AutoRecover information in every [TIME DURATION] minutes” option is checked. You’ll see the predefined (10 minutes) time under the box with an upward and downward button to customize it.

6.   Use the buttons next to TIME DURATION box to change and specify the minutes you want your document to save.

7.    You can also check other options under Save dialog to use them as well for keeping your documents safe from accidentally deleting.

8.   Close dialog and Preferences window, your changes will be saved automatically.

AutoRecover feature is now enabled in your Excel app. Now, whenever you close Excel accidentally without saving the document. The Document Recovery menu will appear when you relaunch the app with the latest version of the document which AutoRecover has saved automatically. You can click on it to continue your work.

Ellen Cooper  is a technology enthusiast who loves writing about new advancements and IT threats on a regular basis. Her work focuses on the latest advancements in the realm of technology, social media, and cyber security at norton.com/setup.

Source:- http://nortonnorton.uk/how-to-enable-autorecover-to-get-deleted-spreadsheet-back-in-excel/

More About the Author

IT expert having deep knowledge about PC antivirus products. Mainly researching and writing blogs.

Total Views: 17Word Count: 650See All articles From Author

Add Comment

Computers Articles

1. Laptop Screen Repair Or Replacement In Andheri East
Author: shahidseo

2. How The Document Management System Is Going To Increase Your Business Productivity
Author: Satish Yadav

3. How To Re-add Missing Dock Icons On Macbook?
Author: Aida Martin

4. Safepots:automate Your Backup.
Author: safepots

5. Get Access To The Cash App Phone Number To Remove Technical Woes
Author: logansah

6. How To Record Clips On The Xbox One?
Author: Aida Martin

7. How To Fix Iphone Cannot Verify Identity Issue
Author: marco

8. How To Fix Microphone Not Working Error On Windows 10
Author: marco

9. How To Install Dlc On Steam: The Complete Guide
Author: jaxson harry

10. How To Fix No Device Detected In Corsair Utility Engine
Author: marco

11. How Challenges Can Thwart Devops Implementation And How To Overcome Them
Author: Oliver Moore

12. Top 3 Reasons To Use Multi Tenant Ip Pbx Solution
Author: sandip Patel

13. Voip Softswitch Solution And Its Benefits
Author: sandip Patel

14. How To Choose The Best Class 4 Softswitch Solution?
Author: sandip Patel

15. Buy Computer Rack To Save Floor Space Of Your Office
Author: rack finity

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: