在Excel 2003中删除无效名称的隐藏名称定义 [英] Deleting hidden name definitions with invalid names in Excel 2003
问题描述
我正在使用这个宏:
http://support.microsoft.com/kb/119826
尝试清理我的excel文件中的隐藏名称。它适用于大多数隐藏名称,但不适用于少数_123Graph名称。我不知道这些名字来自哪里,但是当我尝试删除它们时,我会收到一个1004自动化错误。
to try and clean up hidden names in my excel file. It works for most of the hidden names, but not for a few _123Graph names. I'm not sure where these names came from, but when I try to delete them I get a 1004 automation error.
知识库提到名称与空格可能会导致一个错误。有没有办法删除这些?
The knowledge base mentions that names with spaces may cause an error. Is there a way to delete these?
推荐答案
Excel 2007及更高版本解决了这个问题,但是Excel 2003的快速修复是:
Excel 2007 and above resolves this issue... but a quick fix for Excel 2003 is:
转到工具菜单
- 选项
- 常规选项卡
- 检查R1C1参考样式
然后点击OK。
Go to the Tools Menu - Options - General tab - Check R1C1 Reference Style Then hit "Ok".
然后系统会提示您输入每个损坏的名称的新名称。
You will then be prompted for a new name for each of the corrupted names.
然后你可以返回并取消选中R1C1复选框。
...then you can go back and uncheck the R1C1 check box.
这篇关于在Excel 2003中删除无效名称的隐藏名称定义的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!