Well, I'm a little surprised but in the end I think we're not miscommunicating after all: You're saying that in old versions we
can open two workbooks in separate windows but in 2010 we
have to, and I'm saying that even in 2010 we
can but we
don't have to. So let's figure this out:
Start with our definition of "window", just in case. Here's my process; try to duplicate it at your end and tell me what happens:
- Make sure Excel is shut down, no workbooks open.
- Open a workbook; I don't care whether you do it by double clicking on an .xlsx document or by starting Excel and then using File, Open.
- While you're still looking at this first Excel workbook, select File.
- From the File menu select some option to open another workbook: Open, Recent or New.
At this point, on my machine, both workbooks are open in the same "window"; if I close all windows but Excel, there will be only one "window" displayed (see attachment xw1.png). When I hit <Alt-Tab>, the two workbooks are represented separately, just as if they were in separate windows (see attachment xw2.png); but they're not. <Win-Tab> displays it differently (see attachment xw3.png) but the same conditions apply.
But you say you
always get worksheets in separate windows, and I don't understand how that's happening. Did you just mean "windows" as they appear using <Alt-Tab>? If not, what method do you normally use to open them? When you followed my process above, did the two still come out in separate "windows" (my definition)?
