Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • September 02, 2015, 01:30:47 AM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: MS Office is breaking ALT-TAB  (Read 8083 times)

offe

  • Member
  • Joined in 2011
  • **
  • Posts: 3
    • View Profile
    • Donate to Member
MS Office is breaking ALT-TAB
« on: September 13, 2011, 06:15:33 AM »
Since this is a forum for more advanced users. I would guess that I'm not the only one that get's annoyed by MS and the way they implemented Alt-Tab in Office. Starting back in Office 2k3 (if I remember correct) they introduced an extra icon in the Alt-Tab list if the office program had more than one document open.

Example of broken Alt-Tab
- Open one notepad and two excel spreadsheets
- Focus on notepad
- Alt-Tab to the first excel spreadsheets
- Alt-Tab to notepad
- Alt-Tab twice to get to the second spreadsheet.
Now instead the first excel spreadsheet got focus, since excel now have three icons in the Alt-Tab list. One for each spreadsheet and one for the application.

Is there anyone that have found a fix for this annoyance?
Or does anyone have the knowledge to make a program that fixes it?

Best regards
Ove Halseth


Stoic Joker

  • Honorary Member
  • Joined in 2008
  • **
  • Posts: 5,879
    • View Profile
    • www.StoicJoker.com
    • Donate to Member
Re: MS Office is breaking ALT-TAB
« Reply #1 on: September 13, 2011, 06:31:06 AM »
Hm... Played with it a bit, and can't quite duplicate the behavior (document tab'ed to got displayed). But the standard behavior for a MDI interface (which Excel is), would be to Alt+Tab into it, and then Ctrl+Tab through its open documents/child windows.

Or I could be missing something... *Shrug*

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 12,787
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Re: MS Office is breaking ALT-TAB
« Reply #2 on: September 13, 2011, 06:39:33 AM »
here anyone that have found a fix for this annoyance?

The Office Suite applications can be annoying, and especially Excel...

If you open more than 1 spreadsheet in Excel, there are 2 possible ways to do it:

1) You have 1 "instance" of Excel that has 2 spreadsheets open in it.
2) You have 2 "instances" of Excel that each have 1 spreadsheet open.

Those behave differently. You should check that.

The default is #1. You must explicitly open a second instance of Excel for #2.

Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker

capitalH

  • Participant
  • Joined in 2008
  • *
  • Posts: 71
    • View Profile
    • Donate to Member
Re: MS Office is breaking ALT-TAB
« Reply #3 on: September 13, 2011, 07:00:42 AM »
The problem is Excel has a mixed interface (bit of MDI and a bit of SDI)

To the casual observer (so without going to Task Manager) Excel looks like it is SDI.

For each document there is a task bar entry, and there is no apparent tab in Excel to change documents (yes there is ctrl+tab and the menu entries but I did say apparent)

I would have preferred if Excel went either MDI or SDI.
With MDI they should
1) add a tab with open documents (on the ribbon please)
2) Add a save all option
3) Only one Taskbar+Alt+Tab entry

With SDI
1) one instance/document

Best case scenario of course would be to do both and allow you to choose.

offe

  • Member
  • Joined in 2011
  • **
  • Posts: 3
    • View Profile
    • Donate to Member
Re: MS Office is breaking ALT-TAB
« Reply #4 on: September 13, 2011, 01:10:09 PM »
Ahhhhh, finally ;D
After googling till I almost dropped, I found this:
http://www.tech-arch...006-02/msg00115.html

After all there is an obscure checkbox that let you turn this insane behavior off.
And after reading the post, I found that I have forgotten the craziest behavior: The shared undo across multiple excel documents. Sometimes Excel fails to switch focus to the document that gets the undo command. So when you are pressing Ctrl-Z multiple times trying to figure out why it's not working. You are in fact destroying a document in the background!

Enjoy!

Ove B-)