hi folks, I've been stuck with this seemingly very simple issue for some time and it's super annoying. It only happens on my home PC but not on my office one!
So basically whenever I have more than 1 Excel workbook opened in the same Excel session (or excel container, I don't know what you call it) I have great difficult in switching between these 2 windows. Even if I use "switch windows" option (which is I've already added to the quick access toolbar) it doesn't properly bring up the other workbook that's currently in the background. I have to minimize the workbook in the foreground first before I work with the one in the background!!! I've attached a snapshot of it to get my idea across better.

problem pic1 excel switch window.jpg