less than 1 minute read

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.

The reason is for calculation ambiguity with linked cells. 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.

Thanks Zeeshan.