The workbook cannot be opened or repaired by microsoft

On the Home tab, in the Clipboard group, click Copy. Select an area, starting in cell A1, that is approximately the same size as the range of cells that contain data in the corrupted workbook. On the Home tab, in the Clipboard group, click Paste. With the range of cells still selected, on the Home tab, in the Clipboard group, click Copy again. Note: Pasting values removes the links to the corrupted workbook and leaves only the data. Use a macro to extract data from a corrupted workbook If a chart is linked to the corrupted workbook, you can use a macro to extract the source data of the chart.

Note: The chart can be embedded on a worksheet or on a separate chart sheet. Automatically saving a backup copy of your workbook helps to ensure that you will have access to a good copy of the workbook, if the original is deleted accidentally or if it becomes corrupted. Click the dropdown arrow next to Tools , located next to the Save button, and then click General Options. For more information on saving and recovering earlier versions of a workbook, as well as information on recovering new workbooks that you had not previously saved , see Recover Office files.

Configuring Excel to periodically create a recovery file of your workbook helps to ensure that you will have access to a good copy of the workbook, if the original is deleted accidentally or if it becomes corrupted. In the Save category, under Save workbooks , select the Save AutoRecover information every check box, and then enter a number of minutes.

In the AutoRecover file location box, enter the location where you want to save the recovery file. Make sure that the Disable AutoRecover for this workbook only check box is not selected. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Troubleshooting and support. Excel issues. Repairing a corrupted workbook. Need more help? Expand your skills.

Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? Microsoft Enterprise. Browse All Community Hubs. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for. Show only Search instead for.

Did you mean:. Sign In. Occasional Visitor. Hi, I'm geting two errors while opening Excel template Labels: Labels: Excel. Posted by Anonymous. Labels: Excel Service , Powershell , Sharepoint No comments:. Newer Post Older Post Home. Subscribe to: Post Comments Atom. About Process Our Work Careers. Products Events Blog Contact Us. Virtual Tour.