处理文件时最大的痛苦是文件损坏时。虽然Office 365为其所有文件类型（包括Word、Excel和PowerPoint ）提供了文件恢复功能，但如果这不起作用，则需要大量返工。这篇文章将指导您如何修复损坏的 Excel 工作簿^{(repair a corrupt Excel workbook)}并放置备份方法以便更好地进行恢复。

修复^(Repair)和恢复^(Recover)损坏的Excel 工作簿^{(Excel Workbook)}

当工作簿显示为损坏时，请按照这两种方法修复工作簿。当您打开Excel文件时，在这种情况下，您将收到一条消息，指出文件已损坏或无法打开，或者文件中没有数据。通常，Excel会提供恢复，但如果这不起作用，您可以使用推荐的方法。

手动修复损坏的Excel工作簿^(Excel)

• 打开^(Open) Excel，然后单击文件^(File)，然后单击打开^(Open)。
• 浏览^(Browse)并选择您需要打开的文件，但不要单击“打开^(Open)”按钮。
• 单击“^(Click)打开^(Open)”按钮旁边的向下箭头，然后选择“打开^(Open)并修复^(Repair)” 。
• Excel 将为您提供两种选择。
  • 恢复数据（修复）
  • 修复失败时从工作中提取值和公式。（提取数据^{(Extract Data)}）。

^(Recover)从损坏的工作簿中恢复数据

将工作簿恢复到上次保存的版本：^{(Revert the workbook to the last saved version:)}如果文件在处理时损坏，最好关闭它而不保存它，而不是尝试用损坏的数据保存它。新鲜打开它，它会带你进入一切正常的状态。

以 SYLK（符号链接）格式保存工作簿： ^{(Save the workbook in SYLK (Symbolic Link) format: )}如果打印机损坏，请将文件另存为符号链接，即，当您选择 Save as Type > SYLK时会显示该选项。对提示单击^(Click)是，然后保存文件。

完成后，您需要重新打开文件并将其保存为Excel工作簿。由于我们将所有内容保存为新文件，因此原始文件仍然存在。这种方法的唯一缺点是它只会保存活动工作表而不会保存其他工作表。

使用宏从损坏的工作簿中提取数据： ^{(Use a macro to extract data from a corrupted workbook: )}如果工作表有图表并使用书中的数据作为数据源，那么来自Microsoft的这个宏可以帮助您恢复该数据。

Sub GetChartValues() 
Dim NumberOfRows As Integer 
 Dim X As Object 
Counter = 2

' Calculate the number of rows of data.
NumberOfRows = UBound(ActiveChart.SeriesCollection(1).Values) 
Worksheets("ChartData").Cells(1, 1) = "X Values"

' Write x-axis values to worksheet.
With Worksheets("ChartData")
.Range(.Cells(2, 1), _ 
 .Cells(NumberOfRows + 1, 1)) = _

Application.Transpose(ActiveChart.SeriesCollection(1).XValues) 
End With 
 ' Loop through all series in the chart and write their values to

' the worksheet.
For Each X In ActiveChart.SeriesCollection 
Worksheets("ChartData").Cells(1, Counter) = X.Name 
With Worksheets("ChartData")

.Range(.Cells(2, Counter), _ 
 .Cells(NumberOfRows + 1, Counter)) = _ 
Application.Transpose(X.Values) 
 End With

 Counter = Counter + 1
Next
End Sub

要执行宏，请在Excel文件中创建一个新工作表。然后选择图表，并运行宏。数据将在您创建的新工作表中可用。

如何防止工作簿损坏

虽然这些方法在您有损坏的文件时会有所帮助，但最好有一种恢复方法。这些是您可以启用的一些内置方法，以确保您将来不会丢失文件。

自动保存工作簿的备份副本：

• 打开工作表，然后单击File > Save为
• 选择^(Choose)覆盖相同的文件，但在此之前，单击Tools > General。
• 选中始终创建备份的框。^{(Always create a backup.)}
• 然后保存副本。

这将确保每次您想要恢复工作表时都有备份。

以特定时间间隔自动创建恢复文件：

• 打开工作表，单击File > Options。
• 在保存^(Save)类别下，配置以下内容。
  • 检查选项Save AutoRecover information every 并设置时间。^{( Save AutoRecover information every and set up the time.)}
  • 将自动恢复^{(Setup AutoRecover)}文件位置设置到您知道的位置
  • 取消选中仅为此工作簿禁用自动恢复^{(Disable AutoRecover for this workbook only)}

我希望这篇文章能帮助您恢复和修复损坏的Excel 工作簿^{(Excel Workbook)}。始终确保设置文件的备份配置。

相关阅读：^{(Related reads:)}

• 如何修复损坏的 Word 文件^{(How to repair a corrupted Word file)}
• 如何修复损坏的 PowerPoint 演示文稿^{(How to repair a corrupted PowerPoint presentation)}。

How to repair a corrupted Excel Workbook

The biggest pаin when working with files is when they get corrυpt. While Office 365 offers a file recovery feature for all its file types, including Word, Excel, and PowerPoint, but іf that doesn’t work, it’s a lоt of rework. This post will guide you on how you can repair a corrupt Excel workbook and also place backup methods so recovery works better.

Repair & Recover a corrupt Excel Workbook

Follow these two methods to repair a workbook when they show up as corrupted. When you open an Excel file, in such cases, you will get a message that either the file is corrupt or it will not open, or there is no data in the file. Usually, Excel offers a recovery, but if that doesn’t work, you can use the recommended methods.

Repair a corrupted Excel workbook manually

• Open Excel, and click on File and then click on Open.
• Browse and select the file you need to open, but don’t click on the Open button.
• Click on the down arrow next to the Open button, and choose Open and Repair.
• Excel will offer you two options.
  • Recover Data (Repair)
  • Extract values and formulas from work when repair fails. (Extract Data).

Recover data from a corrupted workbook

Revert the workbook to the last saved version: If the file got corrupt while working on it, it is best to close it without saving it instead of trying to save it with corrupted data. Open it fresh, and it will take you to the state where everything was working.

Save the workbook in SYLK (Symbolic Link) format: In case of printer corruption, save the file as a symbolic link, i.e., the option shows up when you choose to Save as Type > SYLK. Click yes to the prompt, and save the file.

Once done, you will need to reopen the file and save it as an Excel workbook. Since we are saving everything as a new file, the original file is still there.  The only drawback of this method is that it will only save the active sheet and not others.

Use a macro to extract data from a corrupted workbook: If the sheet has charts and uses data on the book as a data source, then this macro from Microsoft can help you recover that data.

Sub GetChartValues() 
Dim NumberOfRows As Integer 
 Dim X As Object 
Counter = 2

' Calculate the number of rows of data.
NumberOfRows = UBound(ActiveChart.SeriesCollection(1).Values) 
Worksheets("ChartData").Cells(1, 1) = "X Values"

' Write x-axis values to worksheet.
With Worksheets("ChartData")
.Range(.Cells(2, 1), _ 
 .Cells(NumberOfRows + 1, 1)) = _

Application.Transpose(ActiveChart.SeriesCollection(1).XValues) 
End With 
 ' Loop through all series in the chart and write their values to

' the worksheet.
For Each X In ActiveChart.SeriesCollection 
Worksheets("ChartData").Cells(1, Counter) = X.Name 
With Worksheets("ChartData")

.Range(.Cells(2, Counter), _ 
 .Cells(NumberOfRows + 1, Counter)) = _ 
Application.Transpose(X.Values) 
 End With

 Counter = Counter + 1
Next
End Sub

To execute the macro, create a new sheet in the Excel file. Then select the chart, and run the macro. The data will become available in the new sheet you created.

How to prevent Workbook corruption

While those methods help when you have a corrupt file, it is best to have a recovery method in place. These are some built-in methods you can enable to make sure you don’t lose files in the future.

Automatically save a backup copy of a workbook:

• Open the worksheet, and then click on File > Save as
• Choose to overwrite the same file, but before that, click on Tools > General.
• Check the box which says Always create a backup.
• Then save the copy.

This will make sure a backup is there every time you want to recover the worksheet.

Automatically create a recovery file at specific intervals:

• Open the worksheet, click on File > Options.
• Under the Save category, configure the following.
  • Check the option Save AutoRecover information every and set up the time.
  • Setup AutoRecover file location to a place which you know
  • Uncheck Disable AutoRecover for this workbook only

I hope the post helped you recover and repair the corrupt Excel Workbook. Always make sure to set up the backup configuration of the files.

Related reads:

• How to repair a corrupted Word file
• How to repair a corrupted PowerPoint presentation.

Related posts

• 如何申请Themes和改变的Excel Workbook外观

• 如何在Excel中停止或关闭Workbook Sharing

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• 如何在Excel spreadsheet中插入Dynamic Chart

• 如何在Excel中使用ISODD function

• 如何在Excel创建和使用Form Controls

• Microsoft Excel正试图恢复您的信息

• 如何更改Excel worksheet Tab的颜色

• 如何启动Word，Excel，PowerPoint，Outlook在Safe Mode

• 如何在Windows 11/10中创建Tournament Bracket

• Microsoft Excel在Windows 10运行时导致High CPU usage

• 如何在Excel中创建Organization Chart

• 如何更改默认File Format，用于保存Word，Excel，PowerPoint

• 如何在Excel使用EDATE and EOMONTH Functions

• 如何编写，构建和使用VLOOKUP function在Excel

• 如何在Excel中使用DCOUNT and DCOUNTA Function

• 如何在Excel中使用DEC2Bin将十进制数转换为二进制数

• 如何Merge and Unmerge cells在Excel