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