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.

Microsoft Word vs. OpenOffice vs. LibreOffice

Office Suit
Image by http://bit.ly/1qGGg5G

With the regained trust in Microsoft and Windows 10, there is some debate about which programs should be used for your everyday computer needs. Should you still use OpenOffice as your go-to office program suite? Or is, with the upgrade, Microsoft Word the better alternative again? What about LibreOffice?

Lets have a look at what the future may bring for the office suite you want to put your trust in.

 

Microsoft Office And Company

Slowly but surely, the number of people that permanently switch to Windows 10 is rising. We can only speculate about the reasons, which can range from being annoyed by the constant pop up upgrade prompt, the improvement the operating system had gone through since the launch of Windows 10, or the overall trust customers start to put into Microsoft’s newest product. Another valid reason, however, could be that the free upgrade to Windows 10 is only available until July 29, 2016! Until then, your system should have been upgraded to Windows 10. Otherwise, you will have to buy it like any other operating system in the past.

Along with the upgrade, I have stumbled about many questions put out into the web of people that consider switching (back) to the Microsoft Office suite. With it’s no less versatile “cousins” out there, OpenOffice and LibreOffice, it is not mandatory to use the Microsoft native office programs. The two aforementioned ones come with basically the same features as Microsoft Word, Excel, PowerPoint and company and even Google has put out their own rivaling office applications in the form of Google Docs, Sheets, Slides and more.

 

The bigger the choice, the bigger the torment.

 

To start of the little forecast of what may be the best choice for you, lets start with a comparison of those three major office suites as well as the services provided by Google:

Office Suite Programs Operating System License & Price Online Availability
Microsoft Office
  • Word processing
  • Spreadsheets
  • Presentations
  • Note taking
  • Desktop Publishing
  • Database management

Separate:

  • Diagrams
  • Vector image editor
  • Windows
  • Partially
    • OS X
    • Linux

Propretary license

89.95 – 679.95 USD

Office Online
Apache Open Office
  • Word processing
  • Spreadsheets
  • Presentations
  • Diagrams
  • Desktop publishing
  • Database management
  • Vector image editor
  • Windows
  • Mac OS X
  • Linux
  • Unix

Permissive free software license

Free

Free plugins available
LibreOffice
  • Word processing
  • Spreadsheets
  • Presentations
  • Diagrams
  • Desktop Publishing
  • Database management
  • Vector & Raster image editor
  • Windows
  • Mac OS X
  • Linux
  • Unix

Free software license

Free

Free plugins available

LibreOffice Online in development

Google Apps for Work
Online
  • Word processing
  • Spreadsheets
  • Presentations
  • Note taking
  • Diagrams
  • Database management
  • Vector & Raster image editor
  • Online

Proprietary license

Free

Fully online

 

Which One Should I Choose?

Taking the table above, many decisions can be made already.

  • Microsoft Office provides a large bandwidth of possible programs as well as an online version of their programs for use “on the go”.
  • However, the cost-free office suites of OpenOffice and LibreOffice are just as versatile when it comes to the available programs as Microsoft and are, furthermore, available for more operating systems.
  • For all online needs, there are the alternatives of Google, where documents, drawings, spreadsheets and more are always accessible from anywhere with a stable internet connection after logging in to your Google account.

With regard to the Microsoft vs. the free alternatives discussion, one could reason that it’s personal preference. Some want to support the open licensing while others rather put their trust into the well-known program they basically grew up with. It is often regarded to be easier to use and more intuitive than it’s free alternatives, and the files created by these programs are compatible with most programs worldwide. With its expansion from being a “pure” office suite to a whole economy of programs and mobile ready applications, Microsoft should certainly not be put aside as outdated.

Read more about File Formats For Saving Files In Microsoft Word.

With regard to the operating system, the Windows users have the whole bandwidth to choose from, while on Mac OS X the Microsoft Office suite is only partially available. Users of Linux can use Microsoft’s service to a certain extend, while it is not available for the Unix OS at all. The free of charge versions are available for all operating systems while the applications provided by Google can be accessed with any browser on any computer or device anyway.

For working online and easy access to all kinds of files, Google has the clear advantage. However, Microsoft is already making a step in the right direction with their Office Online service.

Read more about How To Save Different Document File Formats.

 

Apache OpenOffice or LibreOffice?

Office
Image by http://bit.ly/1UbfJaM

Between the two cost-free versions, the choice is more difficult. LibreOffice is a fork of OpenOffice, which can not only be seen in the shared design, functionalities, descriptions and naming, but also in the usage of the open file extensions like .odt (OpenDocument Text Document), .ods (OpenDocument Spreadsheet) or .odp (OpenDocument Presentation). However, looking at the history and development of both programs, it won’t be difficult to lean more towards LibreOffice.

OpenOffice has gone through many hands. Originating in a failed program called Star Office, it was handed from one developer team to another until it found it’s resting place with Apache who distribute the program and its code under a permissive license. LibreOffice, however, is distributed under two so-called “copyleft” licenses which allow everyone to use the code who is willing to distribute the result under the same license (and not profiting from someone’s hard work for free). This guarantees LibreOffice a much faster and freer development than OpenOffice. Plus, recommendations, wishes and needs uttered by customers can be targeted and implemented a lot faster.

 


In the end, it is your decision which of the functionalities you are looking for in your office programs; whether you are willing to pay for more programs and more wide-spread formats, or whether a free suite with the basic programs is enough for you; whether you work mostly from one desktop computer or whether you want your files accessible and editable from anywhere.

 

10 Microsoft Word Tricks You Should Know

10 Microsoft Word Tricks You Should Know - Online Convert
Image Credit by = http://bit.ly/1QV7Xx5

 

 

Microsoft word has been around for a long time helping many people easily work on documents of all kinds. There are numerous shortcuts and tips which make using the powerful word processor even easier. Check out some of these 10 Microsoft word tricks you may or may not know about below.

 

 

 

 

 

 

1 – By now, most of us know about using the shortcuts ‘Ctrl+v’ and ‘Ctrl+c’ to quickly copy and paste our work in word. But did you know that if you make 3 quick clicks along anywhere in a paragraph, you can quickly SELECT AN ENTIRE PARAGRAPH! Try it.

2 – If you want to return to the last edit point on word, simply press “Shift + F5” to do so. Pressing ‘Shift + F5’ will bring the cursor to the location it was last at before you saved the document. Whenever you have to copy some text from any other parts of the word document, and you want to go back to where you were at to be able to paste it, this is very helpful.

 

You should also check out File Formats For Saving Files In Microsoft Word

 

3 – Want a page break? Hit “Ctrl + Enter” and it will automatically insert a page break for you. Most of us forget this shortcut and simply keep pressing the enter key repeatedly to achieve this. But if you use this quick shortcut, it can make your word editing a lot simpler, easier and faster.

4 – Did you typed the wrong word or want to quickly delete one? If you hold down “Ctrl + Backspace” you can delete the preceding word.

5 – Want to quickly change the text from lowercase to UPPERCASE? Hit “Shift + F3” to do so. When you want to toggle back and forth between upper and lower case letters, this shortcut is very handy. In case you made the mistake of writing in uppercase or lower, then simply use this helpful shortcut to correct it.

6 – For those that want to move an entire paragraph or sentence up or down to another place on your word document? While pressing copy + paste may work, you can actually play with the different spots you want the text in, if you press “Ctrl + Shift + Up or Down” arrows. Simply highlight the paragraph or sentence and move it up or down.

7 – Looking to make the text BIGGER or smaller without having to use your ribbon interface or headings? Simply press “Ctrl + Shift + >” to make the font size bigger. Keep clicking on it until you have the size you want. If you want to make it smaller, simply press “Ctrl + Shift + <“ instead.

8 – Word is so cool. It remembers the last action you performed. If you want to repeat it, simply press “F4.” This means if you just tried making the font bigger or smaller (as per the previous trick), you can simply keep hitting ‘F4’ to continue to perform the same action.

9 – Need more space on your word window? You can instantly hide the ribbon interface in Office. The ribbon, although very helpful, can be intimidating and overwhelming to others. If you don’t want to see it anymore, or at least during the present work you are doing, just press “Ctrl + F1” and it will instantly disappear. You can also click down on the arrow icon which is located at the end of the ‘Quick Access Toolbar.’ Once there, either un-tick or tick the “Minimize the Ribbon” option found on the menu. Another way to access this menu is to right-click anywhere on the ribbon itself.

 

Need help or wondering if you should convert to Word? Then read Convert to Word – Why and How to Do It

 

10 – For those that tend to have multiple word documents opened at the same time, cycling back and forth through them can cost some time and effort. For a quicker way, simply press “Ctrl + F6” and you cycle through all the open word documents. To cycle back, use “Ctrl + Shift + F6.

 

 

Media Files supported by Windows Software

Windows
Image by Les Haines http://bit.ly/1CWJ3rK

There are many free programs you can use to watch videos, listen to audio files, or view pictures and images with. Yet, not many people feel comfortable downloading and installing unknown software – especially since some can’t even open all formats. After having had a look at native Apple files before, we will have a look at media files that are supported by Windows native programs this time.

We will concentrate on Media files like videos, audio files, and images only this time (with the exception of some project files), since document, presentation, and spreadsheet files is a topic for another day.

If you still come across an audio or video file that isn’t supported by your Windows native programs, you can still convert them into a format that can be displayed or played by them. You don’t need any download or installation for these audio converter or video converter as well.

Windows Media Player

The most current version of the Windows Media Player, Media Player 12, got rid of quite a few restrictions the Media Player 11 version still held. It is part of the Windows 7 Starter Edition, Home Premium, Professional, Ultimate, and Enterprise.

Video:

The support of MP4 and M2TS files as well as 3G2, 3GP, and 3GPP files doesn’t come as a big surprise. Especially MP4 became a very popular format for videos and movies, thus the implementation and support by the Windows Media Player was just a matter of time.

What’s more noteworthy is that Windows Media Playe 12 also supports Apple resp. Mac formats as well now, such as MOV and M4V.

  • 3G2, 3GP, 3GPP (not available in Media Player 11)
  • AVI
  • M2TS (not available in Media Player 11)
  • M4V (not available in Media Player 11)
  • MOV (not available in Media Player 11)
  • MP2
  • MP4  (not available in Media Player 11)
  • MPG
  • WMV

Audio:

While the Apple native formats AIF and AIFF have been supported by Windows Media Player before, the Media Player 12 version added support of the M4A file format as well. Furthermore, AAC files can be listened to with the Media Player as well now.

  • AAC (not available in Media Player 11)
  • AIF, AIFF
  • M4A (not available in Media Player 11)
  • MID, MIDI
  • MP3
  • WAV
  • WMA

 

Windows Movie Maker

For getting the most current version of the Windows Movie Maker, Windows Movie Maker 12, the Windows Essentials 2012 package is necessary.

Project:

The following project files that contain information about the video, audio, and other editing processes can be opened and further edited in Windows Movie Maker 12:

  • MSWMM
  • WLMP

Video:

  • WMV
  • M2TS, MTS
  • AVI
  • MP4, MOV, 3GP, 3G2
  • MPEG, MPG, MP2

Audio:

  • WMA
  • AIF, AIFF, WAV
  • M4A
  • MP3

Image:

  • JPG, JPEG
  • TIF, TIFF
  • GIF
  • BMP
  • ICO
  • PNG

 

Windows Media Center

The Windows Media center allows you to watch TV Series, movies, DVD content, and more on your computer. It’s available in the newest version for For Windows 8, 7, RT, and Vista.

Video:

  • WMV
  • M2TS
  • MOV
  • AVI
  • MP4, M4V
  • MPEG, MPG, MP2

Audio:

  • WMA
  • WAV
  • MP3
  • AAC

Image:

  • JPG, JPEG
  • TIF, TIFF
  • RAW
  • GIF
  • BMP
  • PNG

 

Windows Photo Viewer

The Windows Photo Viewer is the default program to view images, photos, and pictures of several formats since Windows 8, 7, and Vista.

The most popular image formats are supported by the Photo Viewer, but it unfortunately does not cover camera raw formats like ARW, CRW, or NEF.

Furthermore, animated GIFs are displayed as still images rather than animated. To display an animated gif in motion, one either needs Internet Explorer (or any other browser) or another picture viewing program that supports animated GIFs.

  • JPG, JPEG
  • TIF, TIFF
  • PNG
  • GIF (no animated GIFs)
  • BMP