How do I make sure all workbooks open separately?

[pogorelichfan]

Hi everyone!

This seems so simple but I can't get it to work in Excel 2007. I want every single file (or workbook) that I ever open in excel 2007 to open as a separate file - NOT opening within the existing window pane, or side by side. How do you program it to always open separate workbooks (have a wide monitor that works great for this)

Help!

 

[kpark91]

Excel 2007 provides a simple solution for users who want to open all Excel files in separate windows. To access this setting, open Microsoft Excel. Click the Office Button and then click Excel Options, which is down at the bottom right side of the menu. Select Advanced, which is on the left, and then scroll down to Display. Select the Show All Windows in Taskbar checkbox and then click OK.


Read more: http://www.brighthub.com/computing/windows-platform/articles/31227.aspx#ixzz1RXVS8OBq​

 

[pogorelichfan]

Thank you SO much - I couldn't find anyone in the office that had an answer for this!