Editing Microsoft Excel (section)

=== Filenames ===
Microsoft Excel will not open two documents with the same name and instead will display the following error:

: A document with the name '%s' is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that is currently open, or rename one of the documents.<ref>{{cite news|url=http://www.thehindubusinessline.com/ew/2004/08/02/stories/2004080200260401.htm|newspaper=[[Business Line]]|location=Chennai|title=Trouble with macros|first=Gary|last=Rajah|date=August 2, 2004|access-date=March 19, 2019|archive-date=July 29, 2010|archive-url=https://web.archive.org/web/20100729203805/http://www.thehindubusinessline.com/ew/2004/08/02/stories/2004080200260401.htm|url-status=live}}</ref>
The reason is for calculation ambiguity with linked cells. If there is a cell {{code|1=='[Book1.xlsx]Sheet1'!$G$33}}, and there are two books named "Book1" open, there is no way to tell which one the user means.<ref>{{cite web|url=http://blogs.msdn.com/b/excel/archive/2009/01/07/why-can-t-i-open-two-files-with-the-same-name.aspx|title=Microsoft Excel – Why Can't I Open Two Files With the Same Name?|archive-url=https://web.archive.org/web/20100729140409/http://blogs.msdn.com/b/excel/archive/2009/01/07/why-can-t-i-open-two-files-with-the-same-name.aspx|archive-date=July 29, 2010|access-date=March 19, 2019|first=Joseph|last=Chirilov|date=January 8, 2009|work=[[MSDN Blogs]]|publisher=[[Microsoft Corporation]]}}</ref>