Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Works: How to Recover Data from a Corrupted Works Spreadsheet
Article ID: 271074 - View products that this article applies to.
This article was previously published under Q271074
Microsoft Works Spreadsheet files are saved as .xlr files. Files with this extension are in the native Microsoft Excel format. Corrupted Works Spreadsheet files may be recovered by using Excel or by using one of the methods that have proven successful for recovering data from corrupted Excel worksheets. These methods include the following:
Method 1: Open the File in Excel (or Another Compatible Spreadsheet)Use this method when you want to preserve formulas and cell formatting. If you can open the file with Excel, follow these steps to recover the data:
Method 2: Open the File in Microsoft WordUse this method if Excel does not open the .xlr file, if you suspect the problem may be a corrupted formula, or if Excel is not available.
If you have the Excel converter installed, you may be able to open your Works Spreadsheet file in Word. If the file does open in Word, you cannot recover cell formulas, but only the results of those formulas that are currently in the cells. You also lose any special formatting.
TIP: To determine if the Microsoft Excel converter is installed, click Open on the Word File menu, and then click the Files of type box; if Microsoft Excel Worksheet is listed, the converter is installed.
To open a Works Spreadsheet in Word, follow these steps:
Method 3: Use the Excel ViewerUse this method if Excel does not open the .xlr file, if you suspect the problem may be a corrupted formula, or if Excel or Word is not available.
If the Excel Viewer is installed, you may open the corrupted Works Spreadsheet file in Excel Viewer, copy the cells, and paste the cells into a new spreadsheet. However, you cannot recover any cell formulas; you can recover only the results of the formulas that are currently in the cells.
For more information about Excel Viewer, visit the following Web site:
Article ID: 271074 - Last Review: August 6, 2012 - Revision: 4.0