Both my partner and I have been working on two different versions of the same spreadsheet recently, and he ended up sending through his copy for me to look at alongside mine. Excel however, had different ideas:
This comes down to a “dumb architecture decision”. I think Excel even acknowledges this:
…even if the documents are in different folders.
Why should this be a problem? Why, Microsoft, Why? This is a software architecture issue I’d expect to see in the 80’s, maybe the early 90’s – but not, for goodness sake, in 2010 (or even 2008, when this version of Excel was released).
As far as I’m concerned, not being able to have two documents of the same name open is just sloppy, lazy programming.