To avoid the confustion of alt-tab switching between Excel windows in
different Excel instances, turn off the Excel option "Windows in Taskbar"
(Tools-Options-ViewTab-WidnowsInTaskbar). Then use alt-tab to swtich
betwen Excel instances (as well as other applications), and within Excel use
Shift-F6 to switch between the windows within the Excel instance.

"Andrew O." wrote:

Hi,

Thanks everyong for the ideas on this. The %1 works indeed but it is a
poor solution when you are running Excel 2007 on a notebok. I have a
Nov 2006 IBM with 1 GB RAM and it takes a while to load a new copy of
Excel 2007.

Another funny problem is that if you open 2 files in one copy of Excel
there are 3 Excel tabs if you use Alt+Tab for navigation. If you open
another 2 files in another copy of Excel, you get 6 Escel tabs via Alt
+Tab, which makes it virtually unusable.

If we don't talk about this issue and don't report to Microsoft, we
are going to "eat ..." forever.

The issues (in my opinion) that can help classify this behaviour as a
bug a

1) Inability to view 2 or more spreadsheets side by side (either on
one screen or on two screens).

2) Confusing behavior of the "Undo" feature. You are used to one
behavious in MS Word (separate list of undo items for each document),
and you have a completely different behaviour for MS Excel (single
undo list for all open documents).

Anyone know how this can be reported to the Excel team?

Andrew