Q: (from Phyllis)
I have been trying to find the default setting in Excel for automatically opening multiple instances when a new workbook is opened. I can manually open them. I am on Windows 7 Pro and Office 2007. Can you give me a shove in the right direction?
It’s interesting – Word and PowerPoint do this by default, but historically speaking, Excel doesn’t. All of the workbooks are associated with the same taskbar icon and therefore making it difficult to show two workbooks side-by-side in Windows 7. We seem to have added an option to correct this starting with Office 2003 and from page 8 of my Tips & Tricks document (https://skydrive.live.com/?cid=9dc1b9c3c6b95b61#!/view.aspx?cid=9DC1B9C3C6B95B61&resid=9DC1B9C3C6B95B61%21892) I believe the following should work:
Show each open spreadsheet on the taskbar (Excel 2007)
Click the OK button
Thanks so much for this info! This function was not checked when I switched to excel 2007 and it has drove me crazy.
Hey, actually that does work for showing them on the task bar (i'm using office 2010) but unfortunately the problem is not solved as excel still groups the multiple instances in the window, not allowing one to view 2 windows side by side unless minimizing the both instances and resizing within the excel window. There has go to be a way to fix this!! absolutely moronic...
Perhaps the Windows option to group similar taskbar buttons together may be relevant here? See this article:
Group similar buttons on the taskbar
Its possible to change it also in office 2013?
Excel is just so different! If an Excel window is closed through the Live Taskbar Preview, then the Live Taskbar Preview also closes! But with Word or IE when a window is closed through the Live Taskbar Preview, then the Live Taskbar Preview just resizes. Is this an intentional anomaly in Excel? or just Excel being different?
Thanks. It worked and problem resolved.
This was a great help - simple and concise. Thank you!
Thanks steve...it worked
Marvellous. I recently upgraded and so I did this in reverse, which is what I wanted to achieve, i.e. only one item on the taskbar and switch workbooks by using the CTRL-TAB or following these daft 'ribbon' menus to Switch Window.
Thanks Steve. its working
The fix is quick.
Go to windows taskbar properties and change the option from "Always combine, hide labels" to never combine.
Hit apply and the excel windows will show on the bar side by side.
Thank you very much.
Thanks steve its working
Thx explained simple and clear.