Saturday 2 August 2014

[www.keralites.net] 10 Ways to Recover a Corrupted Excel File

 

By Susan Harkins


 

Even if you faithfully back up your Excel workbooks, corruption can still be a problem. The backup files won't always contain your most recent work, so you'll probably end up re-entering data. Repairing a corrupted workbook, if possible, is a better option. In this respect, Excel can help. If you attempt to open a corrupted workbook, Excel will engage File Recovery mode, which attempts to repair the workbook. If that works, great! Unfortunately, Excel's automated File Recovery feature sometimes fails to repair a damaged workbook. When this happens, you'll need alternatives. Try the easiest solutions first. The more complex methods usually recover data, but no formulas, formatting, charts, or macros.
Note: This article is also available as a PDF download.
 

1: Let Excel try

If Excel's automatic recovery mode fails, there's a manual feature for recovering a corrupted workbook:
 
  1. Choose Open from the File menu. In Excel 2007, click the Office button and select Open.
  2. Using the Look In control, locate and specify the corrupted workbook.
  3. From the Open button's dropdown list, shown in Figure A, choose Open And Repair.
  4. If this is your first attempt to manually recover the workbook, click Repair in the resulting dialog box, shown in Figure B.

Figure A


 
Attempt to manually recover a corrupted workbook.

Figure B


 
You can repair a workbook or extract the data from a corrupted workbook.
If you're lucky, Excel will repair the file. However, this feature recovers files when something goes wrong with Excel, so it won't recover every corrupted file. Once you've made every attempt to recovery the file, you might have to make do with recovering just the data. When that's the case, click Extract Data in step 4.
 

2: If the corruption occurs while the workbook is open

If corruption occurs while the workbook is open, do not save the workbook. You'll just save whatever corrupted the workbook along with the most recent changes. Instead, revert to the last saved version. Doing so, without saving first should discard the corrupted component. You'll possibly lose data, but often, you can rebuild quickly enough (a good reason to save your work often).
To revert to the last saved version, do the following:
 
  1. Choose Open from the File menu. In Excel 2007, click the Office button and select Open.
  2. Using the Look In control, locate and specify the corrupted workbook.
  3. Click Open.
You're really just reopening the workbook — there's nothing special going on.
 

3: Disable automatic calculation

If Excel fails to open the file on its own or via the Open And Repair option, try setting the calculation method to manual and try again. To reset the calculation setting:
 
  1. Open a new blank workbook.
  2. From the Tools menu, choose Options and click the Calculation tab. In Excel 2007, click the Office button, click Excel Options, and select Formulas in the panel to the left.
  3. In the Calculation section (Calculation Options in Excel 2007), click Manual.
  4. Click OK.
Then, try to open the corrupted workbook. Sometimes Excel can open a corrupted workbook if it doesn't have to recalculate.
 

4: Try Microsoft Office Tools

If Excel can't open the corrupted workbook, give Microsoft Office Tools a whirl:
 
  1. From the Start menu, choose All Programs (in Windows XP).
  2. Select Microsoft Office.
  3. Choose Microsoft Office Tools.
  4. Select Microsoft Office Application Recovery.
  5. In the resulting dialog box, shown in Figure C, choose Microsoft Office Excel.
  6. Click Recover Application. The process could take a few minutes.
  7. Respond to the Send Report To Microsoft prompt.

Figure C


 
Office Tools might recover a corrupted workbook.
The recovery tool will close Excel and then restart it, displaying a list of recovered workbooks (if any). If you're lucky, your corrupted workbook will be in the list. Simply open it and count your blessing.
 

5: Move the file

Sometimes, a corrupted workbook isn't really corrupted in the traditional sense. It just isn't accessible as usual; networks and servers often mask errors as corrupted files. If you encounter a seemingly corrupted workbook that Excel can't repair, move the corrupted file to another folder, drive, or server.
 

6: Let the competition try

Some people claim extraordinarily good results using OpenOffice Suite, a free open source alternative to Microsoft Office. This suite's Excel counterpart, Calc, should open a corrupted Excel file. Unfortunately, it means a lengthy download, but if it works, it's well worth the effort.
 

7: Open the corrupted workbook in WordPad or Word

If you can't repair the workbook, try opening it in WordPad. If it works, WordPad will convert everything to text — but you'll be one step closer to recovering important data. Unfortunately, this method won't recover formulas. On the other hand, unlike many other data recovery methods, WordPad will recover your VBA procedures (macros). Simply search recovered text for Sub and Function to find them.
You might also be able to open the corrupted .xls file in Word, but the results will be limited. For this method to work, you must install the Microsoft Office Excel converter. And unlike WordPad, Word won't recover your procedures.
 

8: Use external references

Sometimes, you can recover data by referring to the actual cells in a corrupted workbook. You won't recover formulas, formats, charts, macros, and so on, but recovering the data is better than recovering nothing. To recover data by referencing the corrupt workbook, do the following:
 
  1. Open a new workbook and enter into cell A1 a formula in the following form to reference A1 in the corrupted workbook: nameofcorruptedworkbook!A1. (You don't need to include .xls in the filename.)
  2. Press Enter.
  3. If the corrupted workbook isn't in the same folder, Excel will display the Update Values: nameofcorruptedworkbook dialog box. Use the Look In control to locate the corrupted file. Select the file and click OK.
  4. If the Select Sheet dialog box appears, as shown in Figure D, select the appropriate sheet and click OK. Excel will display the value in cell A1 of the corrupted workbook.
  5. Select cell A1 and drag it across as many columns as needed to accommodate the data in the corrupted file. If Excel displays the Update Values: nameofcorruptedworkbook dialog box, select the corrupted file and click OK.
  6. Repeat step 5, copying row A down as many rows as necessary to accommodate the data in the corrupted file.
  7. Select the data and choose Copy from the Edit menu.
  8. Select Paste Special from the Edit menu and choose Values, as shown in Figure E.
  9. Click OK.

Figure D


 
If the corrupted file has multiple sheets, specify a sheet.

Figure E


 
Replace the referencing formulas with data.

9: Try SYLK format to recover data

Microsoft recommends using the SYLK format to filter out corrupted elements, especially if the corruption is printer related. You must be able to open the corrupted workbook for the following to work:
 
  1. From the File menu, choose Save As. In Excel 2007, click the Office button.
  2. From the Save As Type control, choose SYLK(Symbolic Link) (*.slk), as shown in Figure F.
  3. Give the active sheet a descriptive name, such as corruptedworkbooknameSheet1. If the workbook has only one sheet, this step is unnecessary.
  4. Click Save.
  5. If the workbook has multiple sheets, Excel will ask you if you want to continue because the selected format doesn't support multiple sheets. Click OK.
  6. If Excel prompts you with a warning that the workbook might contain features that aren't compatible with the SYLK format, click Yes.

Figure F


 
Save each sheet using the SYLK format.
It's important to know that the SYLK format saves only the active sheet. However, you won't notice that the format has stripped all of the pages but the active one until you close and reopen the .slk file. To recover data from all the sheets, you must reopen the corrupted workbook and save each sheet individually. That's why step 3 instructs you to give the sheet a descriptive name. You'll find those names helpful when reconstructing the multiple-sheet workbook.
After saving all the sheets to the SYLK format, open one of the .slk files and rename it using the .xls format. Be careful not to use the corrupted workbook's name. Once you've reconstructed the workbook, you can discard the corrupted file or rename it, freeing up the original name. Don't replace it until you're sure you've recovered as much data as possible. Then, reconstruct the workbook by importing or copying data from the .slk files. It's a tedious process, but worth the effort if nothing else works. This method saves values resulting from formulas, but not the formulas themselves.
 

10: Recover macros

If you can recover data but not macros via one of the previous tips, you can still save macros — at least sometimes. To try, do the following:
 
  1. Open Excel, but don't open the corrupted workbook.
  2. Set the calculation mode to Manual (see #3).
  3. Choose Macro from the Tools menu, select Security, and choose the High option. In Excel 2007, click the Office button, click Excel Options, and choose Trust Center in the left panel. Then, click the Trust Center Settings button, select Macro Settings in the left panel, select Disable All Macros Without Notification in the Macro Settings section, and click OK twice.
  4. Open the corrupted workbook. If Excel opens the workbook, you'll see a notice that the macros are disabled. If Excel shuts down, this method won't work.
  5. Press [Alt]+[F11] to open the Visual Basic Editor (VBE).
  6. Using the Project Explorer (press [Ctrl]+R), right-click a module, and choose Export File.
  7. Enter a name and folder for the module.
  8. Repeat steps 6 and 7 as many times as necessary to export all the modules.
  9. Close the VBE and exit Excel.
  10. Open a new blank workbook (or the newly constructed workbook that contains recovered data from the corrupted workbook) and import the modules
Source

 

Junaid Tahir 
www.DailyTenMinutes.com

 Follow me on Twitter  View my profile on LinkedIn  Like my page on Facebook  Read my articles on my personal blog  Subscribe to my Feed  Visit my Google+ Page

www.keralites.net

__._,_.___

Posted by: Junaid Tahir <mjunaidtahir@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Yahoo Groups
New - View Group Photos by Time or Location
Enjoy your group's photos beautifully arranged by date or place

KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net

.

__,_._,___

[www.keralites.net] 5 Things to Forget

 

 

 




You are surely so much careful about yourself. You definitely love yourself so much that you take care of yourself more than anyone else in this world. So you must understand how to improve yourself in any field. Improving yourself and your life must be your primary choice.  In the way of improvement, we take so many things seriously while there there are many things we should be so much careful about.

It is said that everyone in this world is selfish. But do you know that there are many things that you can forget about yourself? You dont even have to think about those things. If you have never thought about it, here is list that you can follow.

Forget if You Know Someone Hates You :
In life, there is no point to remember the people who dont love you. Your life is very important. You must live to be loved by others, not to be hated by people around you.  Because you love yourself and what to improve your life. But it doesn
t mean that you have to hate them. Everyone has their own choice. May be, they have found something in you to hate for. If you dont understand the reason why people dont love you, it is better not to think about that. It is a lot better to start living your life in your own way.

Forget if You Know That Someone is Angry on You:
Anger is an inseparable part of our personality. Your life will always keep bringing it in front of you. Actually, it is not actually possible to totally control your anger. But if you try hard to control your feelings and emotions it may be possible. Think about how many times you have been angry in your life till now. It doesnt matter how many times you got angry. What matters is that your anger got always reduced after a certain time. So if you know that a person is angry on you for any reason and you are being tense for that, there is no use.

Improve your mentality and forget the fact that he ( she ) will always be angry on you. Think more about the fact that it will reduce after a certain time. You just need to wait for that time. If the person is very
 
close to you, it is not possible to keep the anger for a long time.  There is something to remember that generally, those who are close to you get angry on you. Those who are not close to you and have no connection with you will never even think about being angry on you. If you know that someone having no connection with you is angry on you, it is not actually anger, this is something more than that. Yes, life is really mysterious sometimes.

Forget if You Miss Someone so Much:
Do you miss someone you love? If yes, i would suggest you not to miss anyone just because he or she is not with you. Missing someone doesnt give any satisfaction of mind. Rather, it only increases your dissatisfaction of your mind. Life is to think about positive things, not to think about the negatives of life. If you are strongly connected with a person, there is no logic in missing that person.
If you miss your life partner so much, think that somewhere in this world, your partner is still with you. Improve your understanding with your life partner. Then it will be a lot easier. However, i have to say that controlling this kind of feelings is a little difficult for people who are in love.

Forget the Fact if You are Alone in This World:
Being alone in this world is not something to regret for. If you are sad for it, let me tell you that there are so many other people who are alone in this world. They also live a lonely life. Being sad for this reason is not actually going to give you anything. But if you prepare yourself to build good and strong connection with the people around you, it is much better than only being sad. Life has so many things to be proud of. Even if you are alone in life, there is always someone with you. It is God. So it is better to forget it and think about building relationship with people around you. Try to improve your connection with people around you. You life has to be easier.

Forget the Things You Can Not Do.
If you are totally unable to do something in your life, it is better to forget everything about it. If you only remember it and get sad without taking serious action to be able to do that, it is better to forget it. Sometimes, we become very much sad when we are unable to do something while people around us can do it. In such times, it is better to work on yourself to improve your ability rather thinking about what you can not do in life. If you are sure that you will never be able to do that, it is better to totally forget it.  Forget your inability to do that and also forget the time you failed. In the beginning, it may be a little difficult for you. But actually it is not. Keeping a thought about your inability to perform a job will only increase your mental dissatisfaction and reduce your self-confidence. Life must be lived proudly with full confidence, not by bending your head all the time. Always think about improving yourself and the quality of
your life.

 
Source: Unknown

 

Junaid Tahir 
www.DailyTenMinutes.com

 Follow me on Twitter  View my profile on LinkedIn  Like my page on Facebook  Read my articles on my personal blog  Subscribe to my Feed  Visit my Google+ Page

www.keralites.net

__._,_.___

Posted by: Junaid Tahir <mjunaidtahir@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net

.

__,_._,___

[www.keralites.net] The 10 Habits Of Happy Couples .....by Jim Harris, Ph.D

 

The 10 Habits Of Happy Couples .

 

 
#1. Go to bed at the same time.

 

 
Remember the beginning of your relationship, when you couldnt wait to go to bed with each other to make love? Happy couples resist the temptation to go to bed at different times. They go to bed at the same time, even if one partner wakes up later to do things while their partner sleeps.
#2. Cultivate common interests.

 

 
After the passion settles down, its common to realize that you have few interests in common. But dont minimize the importance of activities you can do together that you both enjoy. If common interests are not present, happy couples develop them. At the same time, be sure to cultivate interests of your own; this will make you more interesting to your mate and prevent you from appearing too dependent.
#3. Walk hand in hand or side by side.

 

 
Rather than one partner lagging or dragging behind the other, happy couples walk comfortably hand in hand or side by side. They know its more important to be with their partner than to see the sights along the way.
#4. Make trust and forgiveness your default mode.

 

 
If and when they have a disagreement or argument, and if they cant resolve it, happy couples default to trusting and forgiving rather than distrusting and begrudging.
#5. Focus more on what your partner does right than what he or she does wrong.

 

 
If you look for things your partner does wrong, you can always find something. If you look for what he or she does right, you can always find something, too. It all depends on what you want to look for. Happy couples accentuate the positive.
#6. Hug each other as soon as you see each other after work.

 

 
Our skin has a memory of good touch (loved), bad touch(abused) and no touch (neglected). Couples who say hello with a hug keep their skin bathed in the good touch, which can inoculate your spirit against anonymity in the world.

 

 

 

 
#7. Say I love you and Have a good day every morning.

 

 
This is a great way to buy some patience and tolerance as each partner sets out each day to battle traffic jams, long lines and other annoyances.
#8. Say Good night every night, regardless of how you feel.

 

 
This tells your partner that, regardless of how upset you are with him or her, you still want to be in the relationship. It says that what you and your partner have is bigger than any single upsetting incident.
#9. Do a weather check during the day.

 

 
Call your partner at home or at work to see how his or her day is going. This is a great way to adjust expectations so that youre more in sync when you connect after work. For instance, if your partner is having an awful day, it might be unreasonable to expect him or her to be enthusiastic about something good that happened to you.
#10. Be proud to be seen with your partner.

 

 
Happy couples are pleased to be seen together and are often in some kind of affectionate contact  hand on hand or hand on shoulder or knee or back of neck. They are not showing off but rather just saying that they belong with each other.
God's Blessings to you and family. Aloha from Hawaii.

www.keralites.net

__._,_.___

Posted by: Murli dhar Gupta <mdguptabpl@gmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
KERALITES - A moderated eGroup exclusively for Keralites...

To subscribe send a mail to Keralites-subscribe@yahoogroups.com.
Send your posts to Keralites@yahoogroups.com.
Send your suggestions to Keralites-owner@yahoogroups.com.

To unsubscribe send a mail to Keralites-unsubscribe@yahoogroups.com.

Homepage: http://www.keralites.net

.

__,_._,___