打印区域名称冲突 excel-2007 加载项 VB.Net
我使用 vb.net 开发了 Excel-2007 插件。并且它工作正常。但是当我们打开使用此插件创建的旧工作表时，它会显示“Print_Area Nameconflict”错误。请任何人建议我如何解决这个问题。附上屏幕截图。
谢谢
Mitesh
I have developed Excel-2007 Add-Ins using vb.net. and its working fine. but when we open the older sheet created using this add ins it shows the "Print_Area Name conflict" error. plz can any one suggest how i solve this issue. screen shot attached.
Thanks
Mitesh
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我在 Excel Google 讨论组中找到了 讨论 它描述了您的问题以及解决该问题的方法。问题的根源在于工作簿包含一个名为“Print_Area”的用户定义范围，这是Excel本身默认使用和管理的范围名称之一。
I found a discussion on the Excel Google discussion group which describes your problem, as well as a way to address it. The source of the problem is that the Workbook contains a user defined range named "Print_Area", which is one of the range names that Excel itself uses and manages by default.
根据您使用 Excel 的方式，这仍然会影响您（就像刚才那样）。我将德语 Excel 文件加载到设置有“英语显示”选项的 Excel MS365 中。解决方法：使用另一种 Office 显示语言启动 Excel，而该语言必须在 Word 中进行更改。之后，您很可能能够加载文件、打开数据管理器并删除或重命名保留名称，然后您可以恢复到您的首选显示语言。如果这种情况发生在另一种语言上，同样的情况也可能适用。
depending on how you work with your excel, this can still hit you (as it just did). I loaded a German Excel file into an Excel MS365 set up with the English Display option. The cure: Start your excel using another Office Display language which must be changed in Word. After that you will most likely be able to load the file, open the data manager, and delete or rename the reserved names, then you can revert to your preferred Display Language. The same may apply if this happens for another language.