Excel & Windows In Taskbar Issue

[Paul]

Hi, I've been using Excel 2003 for a while now, and just
recently it has stopped opening new workbooks or other
spreadsheets in the taskbar and thus I can't ALT+TAB
between them

Under Tools|Options|View-> "Windows In Taskbar" is
selected.

The wookbooks and spreadsheets are viewable under
the "Window" menu, but no ALT+Tab or taskbar switching.

Excel did this to me a while back, but after re-
installing Windows XP and Office 2003 it fixed it, but I
don't want to go down that path again!

Can anyone provide any advice here?

Please email (remove the spaces) paul @ nds-it . com.

Any help would be greatly appreciated

Regards,
Paul.

 

[Dave Peterson]

You can't hide!

Try ctrl-tab. It'll work with or without windows in taskbar being set.

 

[Paul]

Thanks Dave, that is what I've been doing for now, but it
is not natural for me to do it. I use ALT+TAB for all
other apps.

I forgot to mention that MS Word still works with the
windows in taskbar! Do you know of a registry setting or
where Excel stores this information for "Windows in
Taskbar"?

It was all working fine until a week ago, maybe something
to do with an office update that could have been
installed.

 

[Dave Peterson]

Word and excel are similar, but different--so differences like this don't
surprise me. (Every version they seem to get closer with the user interface
stuff, though.)

In xl2002:
hkey_current_user\software\microsoft\office\10.0\excel\options
(change 10.0 to 11.0 for xl2003????)

There's an key for showwindowsintaskbar
I see a 1 (one) if it's turned on a 0 (zero) elsewise.

There was a bug in xl2k that broke this with shared workbooks.

this was one work-around (xl2k, though. I didn't think it would be necessary in
xl2003):
http://groups.google.com/[email protected]