Show windows in task bar won't stick!

[tina2]

This must have happened with a recent Windows update (Windows & Office 2000) When using Excel, multiple spreadsheets open in a single instance of excel making it impossible to toggle back & forth between sheets using alt-Tab. If you go to Tools/Options/View and check "Show windows in Taskbar" they will show as separate spreadsheets, but I have to re-set the feature every time I close & open Excel.

Anybody know why M$ would do such a thing? (silly question, I know) Is there any way to make this a permanent setting the way it used to be in the good old days?!

Thanks in advance,
Kristine

 

[rdodge]

When you mention multiple spreadsheets, do you mean mulitple workbooks or mulitple worksheets? I presume you mean multiple workbooks, give that's what the option is dealing with.

I have not had this sort of issue with Excel. However, there is one issue that I have noticed with Excel, if Excel crashes, from the time that instance of Excel was opened til the time it crashed, if you made any changes to how the application works or appears, those settings will be lost, so what I have done to avoid that issue is the following:

Save all currently openned workbooks.

Make the necessary appliation level changes (Some options may not be available with not a single workbook open)

Close all open workbooks (Save changes if asked)

Close Application

Reopen Application

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.

 

[sawedoff]

I have MS Office 2000 and Windows 2000, and mine sticks. That option is stored in the registry, under HKey_Current_User/Software/Microsoft/Office/9.0/Excel/Options/ShowWindowsInTaskBar as data 0x00000001(1). Look and see if that is what it shows. If it is not checked, the data is 0x00000000(0) or that key doesn't show at all, depending on whether it has ever been selected.

Sawedoff

 

[tina2]

I think it might have something to do with the fact that the workbooks are shared. I closed everything and the setting was saved. It stayed that way when I opened a couple of non-shared workbooks, but the shared workbooks seem to turn the setting off. Could it be that it was turned off when I shared them? If that's the case, it is not the end of the world