There are times when the Microsoft Office application software to automatically retrieve the unexpected & 39; closed document & 39; with the aid of & 39; Auto and recover your data is saved d & 39; be lost and inaccessible. But what happens when you can not access your data, you can still get it. The answer is yes " ". Why not?
The rapid technology has developed tools such recovery recover and restore the lost data. If you lose your data, you can still retrieve it by performing some basic steps or if they have no hope, you can select third d & 39; usefulness - an Excel file repair software. This article aims to examine the methods and points & 39; s av rent useful in case you lose your data data.
How is corrupted or inaccessible:
Before discuss prevention should d & 39; first look at some causes that because of the excellent & 39; file is corrupted. The causes are: Unexpected
Virus attacks or faulty system & 39; stop power outages media error messages d & 39; error:
" Excel unable to read the file .. ", " & 39; n This file is not in a recognizable format ", " ????. xls file can not be accessed. The file May be read only ", Excel.exe has generated errors and will be closed by Windows. You will need to restart the program, a newspaper d & 39; errors is being created ".
Methods to recover data corruption Excel files:
1. Save the file in HTML format 2. L & 39; use of return on documents recorded feature 3. Open the file in MS Word format 4. Open the file in MS Excel Viewer 5. Disabling macros 6. L & 39; use formulas External Link in another worksheet 7. L & 39; use of & 39; Excel integrated into the detection and repair characteristic 8. Other Procedures
1.Saving in the HTML file format
If you are unable to access the data or & 39; open the worksheet, you can save the file in corruption. Format html and then l & 39; open. To do this, as follows:
a.Click the File menu > & 39; click the Save As option. b.Click the type of file, select Web Page (*. htm, *. html) option. c.Close file d.Again open the file in MS Excel e.Click the File menu and select the Save As option & 39;. f.Click Save as type list and select Microsoft Excel option. Change the file name to create filtered copy without replacing the original & 39; sheet file.
Note: Some features may be lost when the file is saved in HTML format format.
2.Use Back to the registered version of Document
While Working on an Excel spreadsheet, if by chance your worksheet automatically closes or is corrupted before & 39; save the changes, you can try this method to retrieve data:
a.Click the File menu and select l & 39 ; option Open. b.The Open dialog box appears, select the name. xls file on which you work. c.As you select the file. xls, a dialog & 39; s display with the following message: " Revert to Saved Document " d.Click OK
The last saved version of corruption. xls displayed.
3.Open will file in MS Word or WordPad
To open the sheet MS Excel in MS Word, you must install the converter MS Excel on your computer system. If corruption Excel file is opened in MS Word, you& 39;ll be able to recover the text and the result of the formulas that are currently in cells. You May not be able to recover leaves dialogue table leaves, or integrated graphics & 39; No matter what module leaves and the cell formulas.
If conversion WordPad, data recovery is possible in Visual Basic code in modules and modules class. Find the " Sub " and " Function " word to find the file code.
4.Open in MS Excel Viewer
You can recover lost data with & 39; using MS Excel Viewer. MS Excel Viewer is a small program distributed free of charge which allows you to view and print Excel for Windows (2.0 and higher) and MS Excel for Macintosh (v 2.2a and above) spreadsheet files. Installing the application & 39; and then you can copy the cells and paste it into a new worksheet. This method can not get the results of formulas that are currently in the cell and formatting of the file. Thus, you can not recover leaves macro, the module leaves, leaves dialogue, charts or macro VBA macros modules.
5.Disable Macros
Disable while trying d & 39; open corruption excel at file.
6.Use External Link formulas in another Worksheet
Type command in cell A1 d & 39; a new worksheet: = " C: My Documents [corrupt files Name.xls] Sheet & 39; 1! A1
Change the path depending on the location of corrupt files and file name. Copy this code down and more to reflect the range in the file damaged. The values of cells except formulas or VBA codes can be recovered to & 39; using this method.
7.Use d & 39; Excel integrated into the detection and repair feature
The " Detect and Repair & quot ; & 39; S integration of the recovery procedure by data corruption Excel files can also be recovered. Follow the steps to use this feature:
a.Open New Excel worksheet b.Click the File menu and select the option & 39; Open. c.In the Open dialog box, select the file. xls file you want to open. The Open button will activate, click on the arrow and select the & 39; spirit of openness and & 39; repair option. d.Click repair button to start the recovery process and retrieve data & 39; button to retrieve data if Excel & 39; n has been unable to repair a previous workbook.
The Excel with corruption can easily be recovered and repaired by & 39; Using this method.
8.Other the Procedures
As measures mentioned above can help you recover data corruption Excel files, you can also give a test to these measures, & 39; s which may prove useful:
a.Close the Excel file, then again & 39; open. b.This does not, restart your computer, try d & 39; open the Excel file. c.If not it also works, delete the contents of the letter " C: WindowsTemp " file and restart the computer & 39;. d.If this does not work then open the Excel file corrupt in safe mode. This process disables the VBA and Add-ins. Click on the Start menu and select Run option.
Enter the following command: " C: Program FilesMicrosoft OfficeOfficeexcel.exe " / s. Now excel in secure mode start.
Note: If you are working on Excel 2002, Office XP, MS Office d & 39; installation will start you enter the command to Run option. Click Cancel, secure mode start.
e.If this does not work, scan the file against the virus. This could solve the problem. f.You can also try. Copy and paste it. Xls file to another partition, then try d & 39; open the file. This could actually work. g.Finally when you have tried all the above points and it seems that & 39; they will not work, you can select a third utility to recover data from corrupt Excel. There are many Excel file recovery software that are designed to perform data recovery on corruption files.
The Excel file Repair is an efficient software corruption Excel File Recovery software that recovers and restores data corruption leaves excel. L & 39; excellent recovery software cell retrieve data, formulas, graphs, images, hyperlinks and other objects d & 39; incorporated corruption excel sheets.
You can try the free version demonstration of grain excellent software repair and file if the file Excel data recovery software displays your data loss and inaccessible, you can buy the full version of the software.
Excel File Recovery Software supports data recovery from almost all versions of MS Excel including MS Excel 2003, 2000, 97, XP.
Neha Gupta is a technical writer for data recovery Nucleus - supplier of professionals and good recovery software and data recovery services. Contact e-mail for recovery, data recovery, passwords, backup recovery tools.
http: / / www.nucleustecnologies.com
Bookmark it:
1 comment:
For resolving out present situation is ideally suitable xlsx repair. The software has all necessary capabilities such as repairing excel files after power failures, viruses. It can work with files from any version of MS Excel.
Post a Comment