Share via

The Excel file opens normally each time, but after saving, it prompts: "Microsoft Excel has detected issues with some content in 'BU2 Main Revenue-V1.44-260311 Copy.xlsx'. Would you like us to attempt to recover the workbook? If you trust the source of th

kenqj qian 0 Reputation points
2026-05-06T05:19:23.54+00:00

excel表格每次打开是正常的，但是另存后，每次提示 “Microsoft Excel  发现"BU2主营收-V1.44-260311的副本.xlsx"中的部分内容有问题。是否让我们尽量尝试恢复?如果您信任此工作簿的源，请单击”是"。” 还请协助解决下。

  点击 是之后，工作薄修复后；工作薄之中工作表“应收看板”的全部图表缺失了。
```修复内容：修复到"BU2主营收-V1.45-260506.xlsx”

通过修复或删除不可读取的内容，Excel已能够打开该文件。

已删除的部件:部件/xl/drawings/drawing1.xml。(绘图形状)

单击查看修复记录:

C:\Users\PUR225~1.HOD\AppData\Local\Temp\error058080 01.xml

<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error168960_01.xml</logFileName>

<summary>在文件“F:\Desktop\BU2主营收-V1.45-260506.xlsx”中检测到错误</summary>

<removedParts>

<removedPart>已删除的部件: 部件 /xl/drawings/drawing1.xml。 (绘图形状)</removedPart>

</removedParts>

</recoveryLog>
Microsoft 365 and Office | Excel | For business | Windows
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sophie N 14,455 Reputation points Microsoft External Staff Moderator
    2026-05-06T06:09:05.48+00:00

    免责声明：由于您描述的问题是在中国发生的，因此即使您使用的支持网站是英文（en-us），我也会用中文回复您。如果您希望收到英文回复，请随时告知。

    亲爱的 @kenqj qian,

    我理解看到“恢复工作簿”提示会让您感到担忧，尤其是在修复过程中丢失了重要的可视化数据（例如图表）的情况下。

    根据您提供的错误日志，Excel 明确指出 drawing1.xml 组件存在损坏。该文件控制形状、图表和对象的渲染；当 Excel 无法正确解析此 XML 代码时，它会删除整个组件以允许打开电子表格数据，这就是为什么修复后的版本中图表会丢失的原因。

    为了给您提供最准确的解决方案并防止进一步的数据丢失，请您澄清以下问题：

    • “应收账款看板”工作表中的图表是链接到同一工作簿中的数据，还是从外部文件或 Power Pivot 模型中提取数据？
    • 此文件是存储在本地驱动器上并进行编辑，还是托管在共享网络驱动器、OneDrive 或 SharePoint 上？
    • 您是否使用了任何特定的 Excel 加载项或宏来生成这些图表或刷新数据？
    • 您目前使用的是哪个版本的 Microsoft 365？（您可以在“文件”>“帐户”>“关于 Excel”中找到此信息。）

    一旦我掌握了这些信息，我就可以帮您确定这是反复出现的文件损坏问题，还是工作簿中特定绘图对象导致的冲突。

  2. Q&A Assist
    2026-05-06T05:19:37.61+00:00
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    The workbook is corrupted in the drawing part that stores the charts on sheet “应收看板”. Excel can open the file, but when saving it rewrites the package, detects the damaged drawing part /xl/drawings/drawing1.xml, and removes it. That is why after repair all charts on that sheet disappear and the message about removed parts appears.

    To handle this situation, only supported actions are:

    1. Try Excel’s built‑in repair on the original (uncorrupted) copy
      • In Excel, select File > Open.
      • Browse to the original workbook (before it started showing this error).
      • In the Open dialog, select the file, click the arrow next to Open, then choose Open and Repair.
      • First choose Repair to recover as much as possible. If that fails, choose Extract Data to at least recover values and formulas.
    2. If the workbook opens normally but errors only after saving
      • Work in the original file.
      • Immediately save a backup copy before the error appears (for example, with a different name or in another folder).
      • If the error appears again, revert to the last saved version:
        • Go to File > Open.
        • Double‑click the workbook that is already open.
        • Click Yes when prompted to reopen; Excel reverts to the last saved version and discards the changes that may have caused corruption.
    3. If the drawing part remains corrupted
      • The removed part /xl/drawings/drawing1.xml contains the chart objects. Once Excel deletes this part during repair, those charts cannot be restored from that repaired file.
      • Use a known good backup that still contains the charts and copy the “应收看板” sheet into a new, clean workbook.
      • If no intact backup exists, only the underlying data (not the charts) can be recovered using Open and Repair or Extract Data.
    4. Preventive measures for the future
      • Turn on automatic backup or recovery so that a previous version can be restored if corruption occurs:
        • Configure Excel to automatically save a backup copy of important workbooks.
        • Configure Excel to automatically create recovery files at intervals.

    If repeated corruption continues even in new files, move the workbook to a local disk (not a network drive) and test again. If necessary, try third‑party recovery tools as suggested in the documentation.

    References:

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.