^

Microsoft Excel will not open two documents with the same name

Posted on by admin

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.

This entry was posted in Software and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>