Picture your small business’s accounting sheets, your Math homework, or your client list disappearing along with all the lights in the house! In a flash, hours, months, and in some cases years of work are all lost or at the very least expensive to retrieve. By the time you finish reading this article, you’ll be in a better position to prevent that scenario from taking place or to make sure it never happens again.
To set up a fool-proof fail-safe system that insures you never lose another Excel spreadsheet again and subsequently spend hours replacing the data, you need just two things:
1.A thumb/jump drive or an external hard drive 2.Auto Recover
Auto Recover is one of, if not the most valuable setting in the Microsoft Office Productivity Suite. Subjectively, Microsoft Excel users can save a great deal of time, heartache, headache, and money by activating it. There are eleven versions of Microsoft Excel, however this article only covers the last five versions for Windows operating systems and the latest version for Mac
Lets get started. Listed below are the menu paths and instructions to follow in your version of Microsoft Office.This step by step explanation covers Microsoft Excel 2000, XP, 2003, 2007, 2010, and Excel for Windows. Simply follow these menu paths.
Click on “Tools” Click on “Options” Look under “Settings” Check the box that says “Save Auto Recover info every: ” In the option box after the words “Save AutoRecover info every,” choose the number “1” for one minute. In the box after “Auto Recover save location:,” you can either leave it as default or choose a folder you’re familiar with and comfortable navigating to. Click on “OK” at the bottom of the Options Menu.
Click on “Preferences” Click on “Save” in the Sharing and Privacy Section Check the box that says “Save Auto Recover After This Number Of Minutes:” In the option box after the words “Save Auto Recover info every,” choose the number “1” for one minute. Click on “OK” at the bottom of the Save Menu.
At this point you have insured that so long as your computer can start up or the hard drive can be retrieved, you’ll never again lose more than a minute’s data!
To prove that this method works, feel free to type up a short test spread sheet, wait one minute, and reboot without saving.
Thumb, Jump, or External Drive Backup
Most of the time when a system fails the system can be repaired and normal function can continue. There’s no need to utilize backup data because the repair of the main issue allows the user to just continue where he or she left off, as no data has been lost. However, some system failures come with complete data loss. The data lost can be items as small and as simple as the file you were working on at the time of system failure, all the way up to the entire hard drive and the sum of its contents!
To avoid this level of data loss, first purchase a thumb/jump drive or external hard drive. You don’t need the most expensive drive available, just one that comes with its own backup software and suites your size needs. Keep all of your spreadsheets in one easy to find place, such as your “My Documents” folder. Configure the software on your device to backup that specific folder every minute that its connected. And voila! You now have a hard backup of your data and if your hard drive should fail, you haven’t lost many if not any of your important spreadsheets.
In this article I’ve explained how to have both hardware and software backups auto saved to your internal hard drive and any external storage devices you may have. For help with this or any other issues, don’t hesitate to come to or give us a call at 1-888-405-7622 Thank you for your time and I hope this information has been of value to you. Happy computing!