为什么地球上Excel不能处理同名的2个文件？ [英] Why on earth can't Excel handle 2 files with the same name?

问题描述

这让我在整个IT生活中感到烦恼 - 我在二十多年的时间里，与7种不同版本的Excel一起工作，每个版本都有很大的变化，迫使我搜索旧功能在新版本中的隐藏 - 但只有一个事情保持坚实的摇滚：残疾打开两个文件同名。

This bothers me for my whole IT life - I worked with 7 different versions of Excel over 20 years now, with big changes in each version, forcing me to search where the old features are hidden in the new version - but one single thing stays solid as a rock: the disability to open two files with the same name.

对不起，Excel不能打开两个工作簿与同样的名字。

Sorry, Excel can't open two workbooks with the same name at the same time.

所以我真的很期待这里的洞察力，为什么在Excel中仍然是这样2013年，甚至不需要在Excel 95中实现？在Excel数据结构或内部处理中是否有任何技术或设计原因，它无法处理具有diffenrent路径但相同文件名的两个File对象？我不想要微软在这里打，我只是想了解背后的原因。

So I'm really longing for an insight here, why this is still the case in Excel 2013, which was not even necessary to implement in Excel 95? Is there any technical or design reason within the Excel data structures or internal processings that it can't handle two File objects with diffenrent paths but the same file name? I don't want no Microsoft bashing here, I just want to understand the reason behind it.

推荐答案

微软说这里这是由于计算模糊与链接的单元格。

Microsoft say here it's due to calculation ambiguity with linked cells.

如果你有一个单元格='[Book1.xlsx] Sheet1'！$ G $ 33和你有两本名为Book1的书
，没有办法说明你的意思。

If you had a cell ='[Book1.xlsx]Sheet1'!$G$33 and you had two books named 'Book1' open, there's no way to tell which one you mean.

通过所有版本的细节来看，连接的手机名称依然存在，我怀疑它会改变。

This way of referring to linked workbooks by name in cells persists through all versions, and I doubt very much it will change.

这篇关于为什么地球上Excel不能处理同名的2个文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！