Excel错误:已删除记录:从/xl/worksheets/sheet10.xml部分排序 [英] Excel Error: Removed Records: Sorting from /xl/worksheets/sheet10.xml part

查看:8254
本文介绍了Excel错误:已删除记录:从/xl/worksheets/sheet10.xml部分排序的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我几乎肯定我必须创建一个新的excel文件,但也许至少在这里我得到一些想法是什么来源的问题。



我的excel文件不断提供以下错误:



Excel在'filename.xlsm'中找到不可读的内容。您要恢复此工作簿的内容吗?如果您信任本工作簿的来源,请单击是。



所以我做。文件打开修复后显示:



删除的记录:从/xl/worksheets/sheet10.xml部分排序。



细节是我甚至没有sheet10



它是一个大型的excel文件,其中包含自定义对象。但是我没有数据库连接或自动过滤器,因此无法与使用自动过滤标准数组(错误) - 太大的字符串? xlsx错误:已删除记录:来自/xl/workbook.xml部分的命名范围当尝试解决错误



任何人都有一个线索发生了什么?



提前

解决方案

我恐怕不能解释发生了什么,但是我有相似的经历多次 - 总是用XLSM文件。在最新的情况下,我了解到,Excel不喜欢使用两次相同的范围名称,当定义为工作表范围名称(我们认为可以安全地使用它)。



我们的疑难解答路径是:




  • 尝试将文件保存为XLSB(二进制宏文件),并使用XLSB文件或将其保存回XLSM

  • 检查文件历史记录(我们始终保持每日快照),找到问题出现的时间;使用以前的版本和端口您的更改

  • 提取代码(通过SVN代码),创建一个新的工作簿并导入代码



通常步骤1解决了问题,但步骤3从未让我们失败。


I'm almost sure I will have to create a new excel file, but maybe at least here I get some ideas what was the source of the problem.

My excel file is constantly giving the following error:

Excel found unreadable content in 'filename.xlsm'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

So I do. And the file opens as repaired showing:

Removed Records: Sorting from /xl/worksheets/sheet10.xml part.

The detail is that I don't even have a sheet10

Its a big excel file full of custom-objects. But I have no DB connections or autofilter so could not relate to AutoFilter Criteria Using Array (Error) - Too Large String? or xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors.

Anyone has a clue what's going on?

tks in advance

解决方案

I am afraid I cannot explain what is going on, but I had similar experience several times - always with XLSM file. In the latest case I learnt that Excel did not like the same range name used twice, when defined as Worksheet range name (we assumed it is safe to use it that way).

Our troubleshooting path is:

  • try to save file as XLSB (binary macro file) and either use XLSB file or save it back to XLSM
  • check file history (we always keep daily snapshots) and find when the problem firstly occurred; use previous version and port your changes
  • extract the code (via SVN code), create a new workbook and import the code back

Usually Step 1 solves the problem, but Step 3 never failed us.

这篇关于Excel错误:已删除记录:从/xl/worksheets/sheet10.xml部分排序的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆