Microsoft Excel, a popular program for the spreadsheet is an integral part of any organization, small, medium or large. This application is used extensively for the implementation of fast calculations, maintenance of the financial data or records in lists and tables. Corruption is widespread in sophisticated Excel files. The many reasons for corruption are abrupt system shutdown, virus infection, human error factor, application malfunction, etc. is stored by corruption of data in an Excel file inaccessible, so you totally dependent on a valid backup. However, if you do not have a backup, you can try to repair a damaged Excel file on your own by using different strategies Repair excel file provided by Microsoft.
Consider a scenario where you create a workbook with information about your team members salary details in Excel 2007. You try to open the Excel sheet in 2003 version on your office computer, and instead receive the following error message:
"This file is not a recognizable format."
As a result of the above error message, you are not able to access the content of your Excel workbook as they are almost unreadable.
cause
The above error messages and strange behavior of the Excel file in question was recommend it is a case of corruption. The Excel file is damaged and its contents should be put back with the help of the strategies in the next section of this article is available. (Resolution)
resolution
To solve the above error and corruption problem, you must perform the following steps to repair Excel file:
- Set the option of recalculating in Excel to perform manual
first Open Excel, open a blank workbook
second Go to the Tools menu, click Options
third Click the Calculation tab
4.In the Calculation section, click Manual, and then click OK
5.One the File menu, click Open and try to open the file
- Use external references to link the damaged file
1.Go to the menu File Open, navigate to the folder that contains the damaged file, click Cancel
second Click New on the File menu, and click OK
third Type = file name! A1 in cell A1 of the new workbook (File name refers to the name of the damaged workbook). If the Dialog box appears select page, select the appropriate entry and click OK
4.Select A1 cell, the Edit menu, click Edit. Then you choose an area of about the same size as the range the cells that contain data, the damaged workbook, and then click Paste on the Edit menu
5.With in the area of the cells have been selected, click Copy on the Edit menu
6.One on the Edit menu Paste, click OK, select values and click OK. This will remove the links to the damaged file is only the File data
If the above steps do not come to your rescue in the recovery of data from a damaged Excel file, then grab a third Excel repair software.
0 comments:
Post a Comment