How Backup Or Restore To Unsaved Data From Microsoft Office Word, Excel, Powerpoint 2010

Microsoft office gives inbuilt function for auto saved document option available but sometimes unexpected close Microsoft office document like Microsoft office word, Excel, Visio, PowerPoint act,

You can also set auto save time (1 to 120 min) in Microsoft office document manually.

What time we need this data recover option?

1. Suppose you are closing other window from the screen and unexpected you close the Microsoft document like word. Else before that you will see the message do you want to save unsaved data and you have clicked no by you.

2. In the second scenario suppose your system might be crash or power supply problem.
Solutions are given to Backup or Restore to unsaved data from Microsoft office in two different methods one by one in below.

First method to recover Microsoft office document

1. Closed document when you opening it will ask to recover this file. If you don’t find this option than click on Top right office button in below image

Microsft-Office-recover-document

2. Recover unsaved Document automatically visible under this option automatically.

Recover-Micosoft-Office-document

3. Click on this option than unsaved data file open in another Microsoft office window with “save as” option under the top ribbon see in blow image.

Recover-Micosoft-Office-document

4. Click on save as option and get recovered document in your hard drive.

Recover-Micosoft-Office-document

Second method to recover Microsoft office document

Second method should be of use if first method is not helpful

1. For windows 7, Windows 8, and vista user can see the recover data in below path.

C >Users > Your own User name (Folder) > AppData > Local > Microsoft > Office > Unsaved Data
2. And for Windows XP users can see the recover data under below path

C > Document and Settings > you own user name (Folder) > Local settings > Application > Data > Microsoft Office > Unsaved Files
You can also recover doing this in below image also

Backup Or Restore To Unsaved Data

Questions covered in this article,
How to get unsaved data from Microsoft office?
How to recover lose data from Office Word, Excel, Powerpoint 2010?
Where to store unsaved data in computer hard drive?

This must be helps to you. We have been received very positive feedback through the mail. If you have any problem regarding or your suggestion then put your speech in below comment box at last. You can also share through the below social icon.

Set Auto Save Time Option In Microsoft Office Word, Excel, PowerPoint Document

Microsoft office save document in each 10 minutes as default time duration, But you can change it at own time limitation. Ex. If you want to save Microsoft document in each 2 minute automatically than you can set it for each 2 minutes.

This option is available in all Microsoft products including Excel, Outlook, PowerPoint, Publisher, Visio, and Word.

This option is available can be help to protect our use full data, we don’t need to recover data after click on unexpected close button, Or stop power supply, System crash and number tough situations.

This option is available in all past released old version and also available in upgraded version, Microsoft office 2012, and Microsoft office 2013.

Steps to set Auto save Microsoft office document option in below:

Step 1: Click on office button (Top Right) from your opened document. If you don’t find than see below

Microsft-Office-set-Auto-save-document

Step 2: Click on option, for word document it will be rename with Word option, Excel option…act,

Microsft-Office-set-Auto-save-document-2

Step 3: Hit the click on option that you will see second window on your document, than the save minute option under the save tab.

Microsft-Office-set-Auto-save-document-Step-3

GO Save Option > Save > Check box for save auto save information for in minute. You can set minimum 1 minute. Set it as min as possible.

Step 3: Click Ok. Finish

For Manual save Document

If you want to save your document manually, on before and after auto save time period you can do with Ctrl + S from your keyboard.

Related question covered,
How to set office auto save time in settings?
Steps to save document on auto save time
How to set manually time for auto save?
How to decrease auto save document in Microsoft office?


This helping article also helps to other guise. So don’t forgot share this article from the below sharing button.

You can also read our daily helping tutorial on interested subject in your mail box. Subscribe through the blow Email subscription and don’t ignore to activate from your mail box.

Using Excel to make the HTML for the "body" of a table

This article is about how Excel's text functions can be used to make the HTML statements to put inside the body section of a table.   It's written with Blogger users in mind, but applies to anyone who needs to create a large HTML table.   Two Excel example files are provided, one using CSS and one not, which have some formatting included.

HTML table code

Previously I've described tables in your blog:  why you might want to use them, and some options for making a table,

These include using a HTML-code-generator to get the "skeleton" of the table.   With this approach, the hardest part is putting the table content (ie the words, numbers and pictures) into the correct place in the HTML, so that it appears in right cell in the table.

This is easy enough for a small table.   But if you want to make a table with  more data (eg I recently posted a book-index with 100 rows by 5 columns), it can be a little tedious.    Even if you prepare your posts in private (which lets you save frequently without worrying about auto-save), it can still be very hard to make sure that you put the right contents in the right cell.   And because Blogger's post editor doesn't handle tables well, it can sometimes do unexpected things to them,.

But there are some alternatives.

Tools for creating the "body" section of HTML table statements

I'm sure that lots of people have written custom applications that take a text file and turn it into HTML.   (Though when i googled, the first SERPs included a program for Win 3.1 / 95, which most people gave up on a long time ago!).

Many programs like Excel, Word, etc now have an option to save as HTML - so you could just use look at the file they make with a text editior (eg Notepad), and take the relevant bits.   That said, they usually include a lot of extra code, eg for fonts, layouts etc, so you may get more than you bargain for.

Commercial web development packages, eg Dreamweaver, may have table editing tools - however  many people cannot justify the cost of buying and learning them for smaller jobs.

Another option is to use Excel to manage your table of data, and use it's text-string manipulation functions to turn it into valid HTML code.   This isn't as hard as it sounds, especially if someone else does the initial formulas for you.

Excel Templates for making HTML

First version -  cell level formatting - no CSS

Second version  with CSS styles

The first template was made before I understood CSS:  it uses text-functions to put formatting code into every single table cell - though you can just leave things blank if you don't want them formatted.  It may be best to use if you don't understand CSS.

The second template uses CSS styles to format the table.   This means you can change the formatting of all the tables in your website just by changing the CSS rules, ie you don't have to edit each individual table.   The Excel file lists the  CSS styles you need to define, and the names (eg keyTableOdd for odd numbered rows) show what each style is used for.

Version 2:  the formula area is green,
the input area is yellow, and the output area is orange

To use these templates:

1  Download the template


2  Check the formatting settings in the template.  Set up CSS styles in your website if you are using the 2nd version.


3  Create table header and footer statements yourself, or by using an HTML table generator.


4  Adjust the Excel template, so that

• the number of rows and columns in the data area is what you need,
• the formulas in the output area are right for your chosen rows and columns
  
  The section below explains the types of formulas used:  you can model new forumlas (for new columns) on the current ones, and new rows can be made by copying the formulas from an existing row.

5  Put the data for your table into the data area in the spreadsheet


6  Copy the text from the output area, paste it into a text editior (eg Notepad)


7  Use the text editor's Find/Replace function to change all cases of three apostrophes in a row (ie ''') into double quotes.


8  Copy the changed text from your text editor into the "body" section of your table statement.


This sounds like a lot of work but I've found that even if a table is only 10 rows long, using a HTML-generators-spreadsheet is a lot more efficient than trying to type the values into it row-by-row.

Understanding the Excel templates

I'm assuming that you understand a little about how Excel stores data in cells, and refers to those cells by their Row/Column combination, eg "E5" - if not, check out an Excel tutorial before reading on

Also, you need to understand the ideas of copying formulas between rows, and the use of relative co-ordinates in them to make sure that each new row or column picks up the right values. Again, an Excel tutorial would be a good idea if you're not familiar with copying formulas.

As well as these general ideas, there are here are two Excel concepts that are the basis of these templates:

1   Text concatenation functions

Excel has a wide range of functions that are used to glue strings together, or to pull them apart.   Important ones used in these templates are:

= "whatever"   puts a text-string with the characters whatever into the cell
= a1 & b1   combines the text strings in cells a1 and b1   (b1 goes immediately after a1)
= "This is A1: " & a1 & ".   This is B1: " & B1 &"."

The third function combined the two first ones.   It makes a text string like     "This is A1: AahOne.   This is B1: BeeOne."

Notice that it is a bit fiddly:   there are spaces inside the text-strings, and a full-stop at the end, so that the output looks sensible.   To make it easier to read, I've put the conent that's inside double quotes (ie "  ") on a pink background.

Once you understand this type of formula, though, it's not a big jump to formulas like these which combine HTML commands and values from the cells in the spreadsheet.

="<tr class='''"&A21&"'''>"
=" <td class='''keytableID'''>"&B21&"</td>"
=" <td> " & C21 & "</td> "
=" </tr>"
=E21&F21&G21&H21

This uses a step-by-step formula creation, which makes the parts of the final statement, then glues them all together in the last formula..

2   Putting an Excel special character in the output:

HTML needs to have double-quote characters around things that should be shown as text - for example

<a href="A-FILE-URL">Anchor-text</a>

However in Excel, the double-quote is used to show the beginning and end of text strings.

At first , this may put people off using Excel,   But there is a very simple way around this:

1. Use another (set of) characters that don't appear in the table instead, and
2. Before you use the the generated code, use a text-editor (eg Notepad) to change them to the required special characters.

Other ways to make table contents

There are lots of other ways to make the table-contents HTML code.

• Using MS Access would probably be eaiser (but lots of people don't have it). 
• Using Google Docs - spreadsheets is free, but I haven't tried out the string functions yet.
• GreenLava of BloggerSentral has recently recommended Tabelizer:  I haven't used this myself yet, but it also looks promising.

What other options can you suggest?

---

Related Articles:

Why use tables in your blog

Get your posts right before you share them with the word.

Adding a new CSS formatting rule to your blogs' template

Putting HTML into your blog

Understanding Google accounts

File hosts - places to store files you use

Comparing Two Text Files - using Excel

This article is about comparing two text files, making a list of the differences between them and categorising each difference according to whether you care about it or not.   An Excel file tool (available for download) is used, because this helps with making the final list.

The tool was made to support comparing two Blogger templates,as part of Seven Simple Steps to a Snazzy New-look Blog.  But it can be used for many different types of file-comparisons where you need to think about the between the files, keep track of individual differences, and plan actions based on them.

In theory, you can compare two text-files line by line manually. But in practice, especially when the files are made from code like HTML and not English-language sentences, this is very hard to do:  even a one-character difference may be significant, but hard to see.

There are many existing tools that will compare two files.   But a spreadsheet works just as well - and it has other features that can be used to help with making a plans based on the differences found, and tracking progress with fixing them.

I've put some notes about where to put the comparison text files, and how to use the formulas into the spreadsheet, and some detailed pictures below.  But the main point is that when you find a difference you need to:

• Work out where the difference ends, 
• Insert some blank cells in the other column so that the code lines up again,
• Re-copy the comparison formulas into column F (because the insert will have mis-aligned the existing ones),
• Make notes about differences as they are found - this list is important for deciding what to do next.

Preparing to compare text files

Get the two template files that you want to compare, and open them with a text editor (eg Notepad).

They will look ugly and hard to work this - this is ok, the next step puts them in a better format.

A text file, viewed in Excel and looking ugly

Download the Excel tool for comparing text-files.

Paste the contents of the template file from your real blog in the left-hand column.

Paste the contents of the template from your test-blog in the middle column.


Paste the contents of the comparison formula cell (ie the red-shaded one) into every row where there are contents from either of source files.

NB  the comparison forumla is    =IF(D8=A8, "", "Not the same")

In the spreadsheet the cell is shaded red, and you cannot see it unless you look in the formula bar  (this makes the pictures easier to read). 

Doing the Comparison

In Column F, look for the first row when "Not the same" is displayed.

Look at the code for that line, and work out what caused the difference, and whether it's is due to a customisation that you made and want to keep, or someone that you don't want to keep, or something else that Google have done in the meantime.

If the difference is due to a customisation that you want to keep, then make notes about this into the Comments and ToDo columns.

In the example shown, the first difference line is a meta-tag, which I do want to keep, but the second is just the tag-close command:  I don't need to put it separately into my plan, so it's marked "no".

Re-match the lines of code: 
If the difference was due to extra code, then

• insert some extra rows in the other column so that the matching code lines up again, AND
• re-copy the comparison forumula into the rows from there down.

Repeat these steps until all the differences are understood.

At the end, copy the comments and notes columns into another worksheet, and use Excel's sort functions to extract a list of the differences that you need to deal with.

(I like to use Excel to keep lists of planned changes too - but that's a whole different topic.)

---

Related Articles

Making a test-blog for testing template changes

Seven simple steps to a snazzy new-look blog.

Showing a PowerPoint presentation as a slideshow in your website

Planning changes to your blog - in private