I am running Excel 2010 under Windows 7. I often have two or more copies of Excel open. (Sometimes this is preferable to having multiple documents running under one copy.)
The situation is this:
I have Excel copy 1 open with spreadsheet 1 displayed. I open Exel copy 2 and touch a cell to make it the active copy. Using Windows Explorer I double click on spreadsheet 2, expecting it to open on Excel copy 2. That is the way it worked for me on XP. However, under Windows 7, spreadsheet 2 will open as a second document under Excel copy 1.
In other words, now have both spreadsheets open under the first copy of Excel, whereas I wanted one sheet in each. The only way I can get Excel copy 2 to open a spreadsheet is to use the Excel file open dropdown. That works but is very inefficient for me.
Bookmarks