blocks|key|160727|text|微软表示，here是由于链接单元格的计算不明确所致。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|160728|如果你有一个|160729|+='Book1.xlsxSheet1'!$G$33并且你有两本名为'Book1‘的书是打开的，就没有办法知道你指的是哪一本书。|blockquote|160730|160731|160732|这种在单元格中按名称引用链接工作簿的方式在所有版本中都存在，我非常怀疑它是否会改变。|160733|entityMap|0|LINK|mutability|MUTABLE|url|http://blogs.office.com/2009/01/08/why-cant-i-open-two-files-with-the-same-name/^0|5|4|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@]|C|$]]|$1|I|3|-4|5|6|7|10|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|13|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]]]

Microsoft say <a href="http://blogs.office.com/2009/01/08/why-cant-i-open-two-files-with-the-same-name/" rel="noreferrer">here</a> it's due to calculation ambiguity with linked cells.

<blockquote>
 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.
</blockquote>

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

blocks|key|164599|text|对于在这里结束的所有人，因为他们想要同时打开两个同名的Excel文件：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|164600|尽管由于包里克在his+answer中陈述的情况(当然有问题)，Excel本身不允许这样做，但至少存在允许在不同的Excel实例/进程中同时打开多个同名的xls/xlsx文件的变通方法。|offset|length|164601|this+thread+on+the+How-To+Geek+forums中对解决方法进行了说明。|164602|在设置Ignore+other+applications+that+use+Dynamic+Data+Exchange+(DDE)的帮助下，甚至有一种“内置”的修复，这对我很有效，但在关闭Excel，然后通过双击再次打开一个文件时会导致错误。|style|CODE|164603|我不得不去修复注册表，它工作得很好。尽管注意到，一旦应用此解决方法，将防止所有打开的Excel表格(以及具有不同名称的表格)之间交叉引用单元格，因为独立的Excel实例彼此不知道(至少根据我刚才所做的测试)。|BOLD|164604|相反，您可能希望选择修复程序，该修复程序将向资源管理器添加一个新的上下文菜单项Open+Separate，并且仅当您实际上想要同时打开两个同名文件时才使用它。|164605|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/21773920/1236781|1|http://www.howtogeek.com/forum/topic/open-spreadsheets-in-completely-separate-windows^0|0|8|A|0|0|0|11|1|0|3|1Q|0|K|2C|0|0|27|13|D|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@$D|12|E|13|1|14]]|A|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@$D|16|E|17|1|18]]|A|$]]|$1|H|3|I|5|6|7|19|8|@$D|1A|E|1B|J|K]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1C|8|@$D|1D|E|1E|J|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1F|8|@$D|1G|E|1H|J|N]|$D|1I|E|1J|J|K]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]|Y|$5|T|U|V|A|$W|Z]]]]

For all the people who end up here, because they would like to open two Excel files with the same name at the same time:

Even though Excel itself does not permit to do so due to (certainly questionable) circumstances stated by Baldrick in <a href="https://stackoverflow.com/a/21773920/1236781">his answer</a>, there at least exist workarounds which allow to open multiple xls/xlsx files with the same name at the same time in separate Excel instances/processes.

The workarounds are explained in <a href="http://www.howtogeek.com/forum/topic/open-spreadsheets-in-completely-separate-windows" rel="noreferrer">this thread on the How-To Geek forums</a>.

There is even a sort of "built-in" fix with help of the setting <code>Ignore other applications that use Dynamic Data Exchange (DDE)</code>, which works for me, but leads to errors when closing Excel and then trying to open a file again by double-clicking on it.

I had to to go for the registry fix, which works fine. NOTE THOUGH that this workaround, once applied, will prevent cross-referencing cells between ALL opened Excel tables (also those with different names), since the separate Excel instances are not aware of each other (at least according to tests I just made). 

You may instead want to choose the fix which adds a new context menu item <code>Open Separate</code> to the Explorer and only use it if you in fact want to open two files with the same name at the same time.

blocks|key|2755640|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2755641|，是的，你可以！(但我认为这是一个Excel+bug)|offset|length|style|BOLD|2755642|2755643|试试这个：|2755644|2755645|在桌面上右击并选择“新建”=>+"Microsoft+Excel+worksheet".|ordered-list-item|2755646|Rename文件到"Test1.xlsx“(名称很重要！)|2755647|现在在桌面上创建一个文件夹，并将文件"Test1.xlsx”的副本粘贴到其中|2755648|通过双击打开两个"Test1.xlsx“：Et+both|2755649|2755650|现在，这两个(同名)工作簿在Excel中打开。但是，如果你查看那里的“测试”-Properties，它会变得更加奇怪，因为在内部，它们都被重命名为“Workbook.Name(1).xlsx”。|2755651|这是因为Excel的公式在内部确实需要特殊字符"[]“。|2755652|所以它们(通常)是不允许作为工作簿名称的，但是外部名为"Test1.xlsx“的工作簿无论如何都可以打开，对我来说，什么是a+bug！|2755653|为什么？因为作为一个程序员，如果你想通过使用"Application.Workbooksname“来处理这两个工作簿，你真的会遇到麻烦，它不会失败，但总是提供第一个使用这个名字的工作簿！|2755654|约尔格|2755655|entityMap^0|0|0|R|0|0|0|0|0|0|0|L|7|0|0|0|2P|0|0|S|0|0|1V|0|0|2L|0|0|3|0^^$0|@$1|2|3|-4|4|5|6|16|7|@]|8|@]|9|$]]|$1|A|3|B|4|5|6|17|7|@$C|18|D|19|E|F]]|8|@]|9|$]]|$1|G|3|-4|4|5|6|1A|7|@]|8|@]|9|$]]|$1|H|3|I|4|5|6|1B|7|@]|8|@]|9|$]]|$1|J|3|-4|4|5|6|1C|7|@]|8|@]|9|$]]|$1|K|3|L|4|M|6|1D|7|@]|8|@]|9|$]]|$1|N|3|O|4|M|6|1E|7|@]|8|@]|9|$]]|$1|P|3|Q|4|M|6|1F|7|@]|8|@]|9|$]]|$1|R|3|S|4|M|6|1G|7|@$C|1H|D|1I|E|F]]|8|@]|9|$]]|$1|T|3|-4|4|5|6|1J|7|@]|8|@]|9|$]]|$1|U|3|V|4|5|6|1K|7|@$C|1L|D|1M|E|F]]|8|@]|9|$]]|$1|W|3|X|4|5|6|1N|7|@$C|1O|D|1P|E|F]]|8|@]|9|$]]|$1|Y|3|Z|4|5|6|1Q|7|@$C|1R|D|1S|E|F]]|8|@]|9|$]]|$1|10|3|11|4|5|6|1T|7|@$C|1U|D|1V|E|F]]|8|@]|9|$]]|$1|12|3|13|4|5|6|1W|7|@$C|1X|D|1Y|E|F]]|8|@]|9|$]]|$1|14|3|-4|4|5|6|1Z|7|@]|8|@]|9|$]]]|15|$]]

<hr>

YES YOU CAN!!! (But I think this is an Excel bug)

<hr>

Try this: 

<ol>
<li>On your Desktop right click and choose "New" => "Microsoft Excel
worksheet".</li>
<li>Rename the file to "Test[1].xlsx" (the name is important!) </li>
<li>Now create a now folder on the desktop and paste a copy of the file "Test[1].xlsx" into it </li>
<li>Open both "Test[1].xlsx" via double click: Et voilà!</li>
</ol>

Now the two (same named) workbooks are open in Excel. But if you look into there "Workbook.Name"-Properties, it gets even more strange, because internally they are both renamed to "Test(1).xlsx".

That's because Excel does need the special characters "[]" internally for its formulas. 

So they are (normally) not allowed for a workbook name, but a workbook which is named "Test[1].xlsx" externally can be opened anyway, what is a bug for me!

Why? Because you really get into trouble as a programmer if you want to address both of this workbooks by using "Application.Workbooks[name]", which does not fail, but delivers always the first one found by this name!

Jörg

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.

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

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.

Why on earth can't Excel handle 2 files with the same name?

数据结构

这困扰了我整个IT生涯-- 20多年来，我使用了7个不同版本的Excel，每个版本都有很大的变化，迫使我去搜索新版本中隐藏了哪些旧功能--但有一件事是坚如磐石的:无法打开两个同名的文件。很抱歉，不能同时打开两个同名的工作簿。所以我真的很想在这里得到一个洞察力，为什么在Excel 2013中仍然是这样，甚至不需要在Exc...

问为什么Excel不能处理2个同名的文件？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问为什么Excel不能处理2个同名的文件？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问为什么Excel不能处理2个同名的文件？
EN