How To Recover Unsaved Microsoft Excel Files

How To Recover Unsaved Microsoft Excel FilesNothing could be worse than doing some really hard work on a project using Microsoft Excel, only to lose some, if not all. This often happens to people due to several scenarios. In some cases, a person may close out the file accidentally without saving it. Other times, their computer may crash without warning. A few may have the device they are using, freeze and stop working. No matter which one of these or other things happened, it is a nightmare. Losing a file before saving it, can drive anyone mad; especially if you been working on it for a long time.

This guide on how to recover unsaved Microsoft Excel files will come in handy, if this ever happened or happens to you. There are some steps you can take for recovering lost or unsaved Microsoft Excel files. By using these tips, you won’t have to start the work all over again. Keep in mind that you may not get the last version of the document you used though. Still, it is far better than losing it all completely. Or having to start the project all over again from the beginning.

Recuperating Overwritten Excel Files

This function works for those who save their files to OneDrive. If you are not one of those who uses this method to save them, these tips will probably change your mind. That’s because OneDrive is a great tool with many benefits. It keeps a history of projects you are working on, by particular versions. That means you can browse through it and find the files you like. Once you find it, you can restore it from whatever version you wish. It is best to save the documents to the Document folder.

You may also be interested in All You Need To Know About Microsoft Word DOCX Files

If you haven’t done so already, you can do this process by going to Onedrive.live.com and using their browser interface.

1.Find the folder you saved your file to and click on it.
2.Next step is to right click on it and select ‘Version History.’
3.Once you reach the Version History, you will find the versions you are looking for.
4.Choose the Restore option and that will overwrite any current versions you may have of the Excel document.
5.You can also choose to Download a copy of the version as well, just in case.

Unsaved Excel Workbooks Recovery

In the event that you have lost or need to recover an Excel file, you can use the Workbooks feature. The function is called Excel’s Recover Unsaved Workbooks.
To check and see which version of the unsaved Excel file is available on Workbooks, follow these steps.

1. Go to File and then choose Open.
2. Select the Recent tab.
3. Scroll to the bottom of the screen to find the “Recover Unsaved Workbooks” feature.
4. Select the Recover Unsaved Workbooks button and click on it.
5. Once you click on it, you will see the list of any and all Workbooks unsaved files.

Chances are you may be lucky and the file will be there. If so, then you can simply select it and hit it so it can load up once again. Just in case you are able to recover it, be certain to save it immediately this time.

File History Versions Restoration

A few people make the mistake of not using OneDrive when they are working with files. If you are one those, you may need to resort to other methods. There is a possibility you can restore the missing Microsoft Excel file.You can do so from the previous versions file history function. That’s if you also have enabled the ‘File History’ function on Windows. For those that have, they can use that function to find and recover older versions of a file.
Follow these steps to recover the lost file if you have enabled File History in Windows.

1. Go to your Windows Explorer and find the file there.
2. Right click on the the file and then choose “Restore Previous Versions
3. That will open up a new window for you and you will then see any of the previous versions of the file. However, if you never created a restore point in Windows, or enabled File History, these options won’t be there.

macOS Users Excel Recovery Options

For those that use macOS, there are different steps that need to be taken in order to recover Excel files. But, if you have OneDrive, you can use the same methods explained above to do so. For those that were not using OneDrive, there is another way.

1. Go to Start and open Finder.
2. Go to Macintosh HD.
3. In the event that Macintosh HD is not showing up, you may have to find another name on your hard drive.
4. Go to Finder and then Preferences.
5. Next, select Hard Disks and then under, Show these items in the sidebar option.
5. You can also go to Users, then (your user name). Next is Library>Application Support>Microsoft>Office>Office 2012 Auto Recovery.

You may have to select the “Show hidden files‘ option if you don’t see any library folder there. To do that, type the following command into your terminal – defaults write com.apple.finder AppleShowAllFiles YES

Don’t miss reading this guide on Microsoft Word vs. OpenOffice vs. LibreOffice

While these may be able to help some people recover any Microsoft Excel lost or unsaved files, it won’t work for everyone. The lesson to be learned here is to always save and backup everything. But, unfortunately, that is something we often don’t do. At least not until it is too late. Don’t wait until you find yourself in a jam to start backing up your work. Using a preemptive strategy, always provides the best results.


Want to get in touch with us? Hit us up on our social media channels!

Tips For Recovering Corrupt Or Lost Documents in Microsoft Office

Tips For Recovering Corrupt Or Lost Documents in Microsoft Office
Image Credit by = http://bit.ly/2eQl3Ap

If you use Microsoft Office frequently then you know how frustrating it can be if you lose your work. It can be due to the file being corrupt or lost. Whether it is while you are using Excel, Word or PowerPoint, the idea of losing your work is a nightmare. In some cases, you may not get the file or document to open up at all. In others, you only get to see some of the content. The rest of your hard work though, has seemed to disappeared.

For anyone who has spent countless hours, days or even weeks working a project, the thought of losing all that work can make anyone freak out. The idea alone can ruin your day and much more. But luckily there are some tips you can use for recovering corrupt or lost documents in Microsoft Office. It is recommended to first backup all of your files just to be safe. It is something you should do anyway since that will help you in case you ever have a situation like this again.

 

Here are 10 Microsoft Word Tricks You Should Know

 

Tips For Word Documents –

If you have lost or cannot find a Word document, the first thing to do is search for it using the search function. First, begin by typing the name of the document you are looking for. If you don’t remember, or that doesn’t work, then try the second option.

You can type – *.docx – and then press enter. This will allow all of the documents to show up. Check the results for your document file and see if you see it on the list.

Another tip you can use is to close all your Word related processes. Simply press “Ctrl+Alt+Del” keys simultaneously to bring up the Task Manager box.
Once there, check for any Word related processeses such as – Microsoft Word or Winword.exe. Next step is to click on ‘End Process’ to terminate it. Repeat it until all of the related ones are closed. You can either restart your computer or device and then restart Word again. Upon you doing so, you should see the “Document Recovery” task pane appear. Depending on the documents, you will get a notice of all the ones recovered by Word. Click on each one to open them up.

 

AutoRecover Option

You can also use the AutoRecover files option as well. You just hit the file menu and then click Open. Next you hit on the “Recent Documents” option and search for your file there.

You can check out Microsoft.com for a Step by Step guide on how to troubleshoot damaged documents in Word.

For those that have the Ultimate edition of Windows Vista, Business or Enterprise version, there is another option. The same as for those with Windows 7. You can use the shadow copy built-in centre as way to recover an uncorrupted or older version of your files.

To check, simply launch “Explorer” and then right click on the particular folder where the file or document was located. Select properties and the “My Document Properties” box will appear. Here you will see older versions of your original files appear. You can double click on them to see which ones you can re-open. Check the dates to try and get the closest to your last known lost file.

 

Other Recovery & Repair Options To Consider

Another option to try is the “Open and Repair” tool. Microsoft Office allows for some files which may be corrupted to be fixed on its own. Although this usually happens automatically, you can also do it manually. To do this simply choose the file or document you may be trying to repair. Click on the arrow of the ‘Open’ button and choose the ‘Open and Repair’ option.
Depending on the corruption of the file, then it may not take too long or it may be possible. However, this option doesn’t always work as efficient as most might like.

 

You may also enjoy reading 10 Ways To Make Your PowerPoint Presentations Better

 

In the end, the best thing to do is to constantly and continually backup your work. Use Cloud services or programs such as Google Docs. This will allow you to have a copy of your work so you don’t lose everything.

8 Ways To Reset Or Recover Your Lost Windows Password

8 Ways To Reset Or Recover Your Lost Windows Password
Image Credit by = http://bit.ly/1OPEVCL

We all forget or lose things once in awhile. Whether it’s a set of keys, money or phone, misplacing, losing or forgetting something important can drive one crazy. Even worse than losing or forgetting those things, is when you lose or forget your Windows password. After all, most of us work or use our computers all day for just about everything. That makes our Windows logon password extremely important. But before you panic or get worried, relax and read on. We have put together 8 ways to reset or recover your lost Windows password. Most of these tips are easy and can be performed in a matter of minutes. Keep in mind, the majority of these hints and tricks will work on most Windows platforms including Windows 10, 8, 7, Vista, and Windows XP.

Access Computer As ‘Administrator’ –

 

Many people are not aware that Windows has a hidden account on it named ‘Administrator.’ In most cases, these accounts usually do not have a password set on them yet. That means that for those that forget, lose or need to recover their password, using this option can work.

  1. If your computer is on, turn it off and let it reboot. Once it starts, immediately press on the ‘F8’ key. Keep doing this until your laptop or PC displays the boot menu.
  1. VIa way of using the arrow keys, choose “Safe Mode” and then hit “Enter.”
  2. Once the home screen is visible, click on Administrator.
  3. In the event that you do not see a home screen, simply type “Administrator’. Make sure you leave the password field blank.
  4. On the bottom left corner, click on the Start menu, then Control Panel, then User Accounts. Once there you can easily change any user passwords.

Keep in mind that this method may work for some operating systems while it may not work for others. Also, if you know who the administrator of the computer is, then he or she can also reset or recover the password for you.

 

You may also want to read these Tips On Deleting Temporary Files On Windows XP or 7

 

Reset Your Microsoft Account Password –

 

Another easy and quick (in fact, one of the fastest and easiest) ways to recover your lost password is by resetting your Microsoft account password. However, there are 2 things to keep in mind. For one, you will need to do this online so you will need another device to log into your Microsoft account. Second, this step only works for Windows 8 users. And you must also already have a Microsoft account created before hand. If you do not meet any of those scenarios, then you can skip this step and go down to the next other ones.

 

  1. Figure out which email address you are using for your Microsoft account. Keep in mind that you make sure to choose the correct account since most people have multiple email address and accounts that they use.
  2. Go to to the Microsoft Account Password Reset page from any browser on your PC, cellular phone or gadget.

3 Choose the “I forgot my password” option and move on to the next steps.

  1. The rest of the steps are self explanatory and simple to do. Simply keep following them until you finally have your account reset.

 

Use Emergency Boot CD –

 

There is another option that allows users who have lost or forgotten their passwords to use. Windows allows users to use utilities such as the emergency boot cd (EBCD).

 

This tool is designed to help those who have problems with a computer that is unbootable or need to recover data from them.

 

  1. Simply boot the EBCD and choose the “Windows Password Wizard” in the small windows menu.
  2. As soon as you make that choice, you should see a message which will automatically disappear within a few seconds.
  3. Once all of the Windows installations have been run and scanned by the computer, you will see a list which contains all of those Windows installations to choose from. Use the arrow keys to select the proper one.
  4. The next page will show you the account list. It will also show you whether or not each account is locked or unlocked. Use the arrow keys again to select the user and change the password.

  

 

Use Your Password Reset Disk –

 

For those that created a Windows password reset disk, this step is very easy. You may have used a floppy disk or a flash drive. This will all depend on what Windows you are running. If you never created this reset disk, then this option will not work for you.

When and if another option to unlock your computer is found, make sure that you create this disk for future references.

 

Offline NT Password & Registry Editor –

 

Windows offers an offline NT password & registry editor which is a great utility for those users who forget their Windows password. This tool enables users to easily overwrite their Windows SAM File and thus fixing the problem. This method will not work for Windows 10 users as they will need to do it in a different way.

 

  1. Start by inserting your Boot CD and convincing your computer to boot from Bios.
  2. Select on the “Repair your computer” option. Keep going until you get to the option which tells you to choose “Command Prompt.” Make sure you select this option and click next.

3 Type the following command promt as on here in order to backup the original sticky keys file on your computer – copy c:\windows\system32\sethc.exe c:\

  1. Once you have done that, you will copy the command prompt executable (cmd.exe) over the top of the sticky keys executable prompt as seen here =  copy c:\windows\system32\cmd.exe c:\windows\system32\sethc.exe

5 Once the system has copied the command prompt, you will see a message telling you it has been copied.

  1. Reboot your computer.
  2. After you see the login screen appear, hit the ‘Shift” 5 times until you see the administrator mode command prompt once again.
  3. In order to finally reset your password, type the following command –

net user me ResetMyPassord. Keep in mind that you should replace the username and password with your own, whatever that choice may be.

  1. Once you have done that, then you are all set.

Keep in mind that you will want to put back the original sethc.exe file which you erased or removed. You can do this by simply rebooting from the CD again and then opening the command prompt. Once there, just copy the – c:\sethc.exe file back to c:\windows\system32\sethc.exe. and you should be all set once again.

 

Try Guessing Your Password –

 

Since it is very likely that the majority of people have already tried this option, some will find this tip redundant or useless. However, the fact is that trying to guess your old password can work, if you take a few extra steps.

For one, make sure you write down every single option or combination you try. This way, you will avoid using the same ones all over again. Second, think about all of the things your old password could have been associated with. Things such as pet’s names, kids birthday or nickname or a place you are fond of. Whatever the case may be, try guessing it and see it that will work for you.

 

Use A Windows Password Hack Tool –

 

This may be a scenario which many people may not feel comfortable doing. However, when all else has failed, this may be one of the few options you have left. There are several password cracking tools available out there such as Cain and Abel, Ophcrack, John the Ripper or Kon-Boot. Although the idea of using one of these tools is not what you may want, often times, they do work. Do a search to see which one is the most recommended and give it a try.

 

Don’t forget to check out these Easy Ways To Change File Associations In Windows

 

Clean Install Windows –

 

Doing a clean install of your Windows is the very last option you should try. It will mean actually losing all of your data and files. However, since it is an option which will gain you access to your computer, it has to be mentioned in this tutorial guide.

Performing a complete Windows install is a long, and often time consuming process. Because of that, we will not get into the step by step details here. Still, there are many useful videos available showing you how to do it, so it should not be a problem. Remember, keep this as your last option since doing so, will mean completely erasing all of your data.