Excel 2007 : Can't Switch Between Instances via Taskbar??

**NewYears1978** · 05-06-2010, 09:58 AM

I'm not sure how, but suddenly I can no longer use the taskbar buttons to switch between open excel documents when I have more than one open.

Usually and at home on my PC there, when you open multiple Excel documents they are basically opened in their own "instance" of excel, however here at work when I open multiple files they always open in the main excel window...and thus when you click the taskbar button to switch to the other..it doesnt work..

I have to minimize one and then open the other.. it's quite annoying but I can't figure out why or how this happened.

Any ideas?

**shg** · 05-06-2010, 10:01 AM

Excel options > Advanced > Display , tick Show all windows in Taskbar

**NewYears1978** · 05-06-2010, 10:24 AM

Well that option is checked, and the taskbar buttons show, it's just that when you click on them it doesn't work..it just sits there.

I was able to solve the problem by putting a /c on all my Excel shortcuts..which is working as a fix..but still curious what the problem is

**Cuffy70** · 08-23-2016, 08:43 AM

I have pinned the Excel program to the taskbar. I can now switch between workbooks like before.

**Cuffy70** · 08-23-2016, 08:56 AM

Scrap that. Bloody doing it again!

**shirleyxls** · 08-23-2016, 09:09 AM

Not sure what causes it, but I've only ever had the problem when opening files on a network. Even then it was never consistent though so never got to the bottom of the problem - even the same files would sometimes open one way and sometimes the other.