Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
The Excel Team Blog » Why Can't I Open Two Files With the Same Name?

Why Can't I Open Two Files With the Same Name?

This is a common question we hear from customers. The answer: 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. Read More...

Read the complete post at http://blogs.msdn.com/excel/archive/2009/01/07/why-can-t-i-open-two-files-with-the-same-name.aspx

Posted Jan 08 2009, 12:05 AM by Microsoft Excel
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.