The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Excel - Create new window for each spreadsheet by default?

    Discussion in 'Windows OS and Software' started by robbirzell, Jan 14, 2009.

  1. robbirzell

    robbirzell Notebook Consultant

    Reputations:
    20
    Messages:
    132
    Likes Received:
    0
    Trophy Points:
    30
    Does anyone know if there is a way to make excel open a new window for each spreadsheet opened?

    Currently, if excel is running and I click on the icon for a saved spreadsheet, the spreadsheet will open as a tab in the existing window. What I would like it to do is open the new spreadsheet in its own window.

    The reason for this is that it would make it much easier to manipulate the windows on my desktop. Plus, the preview in Vista and Aero Peak in Win 7 only work when each spreadsheet is in its own unique window. I often have 3 or more spreadsheets open at one time and this would make it so much easier to manage.

    Anyone have any ideas??
     
    robbirzell, Jan 14, 2009
    #1
  2. Joltin

    Joltin Notebook Enthusiast

    Reputations:
    0
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    5
    Hi.

    Tools, Options, View(tab). Check Windows in Taskbar. This is on Excel 2002, but there should be a similar option in whatever version you're using.
     
    Joltin, Jan 14, 2009
    #2
  3. robbirzell

    robbirzell Notebook Consultant

    Reputations:
    20
    Messages:
    132
    Likes Received:
    0
    Trophy Points:
    30
    Thanks for the input, but that option was already checked. Even though each spreadsheet shows up as an item in the taskbar, they are all still in the same Excel window.

    I'm using Excel 2007 in Vista Business SP1 and Win7 Beta. Same problem either way.

    I've searched pretty extensively for an answer and I've seen that lots of other people have asked the question. Maybe it's not possible??
     
    robbirzell, Jan 14, 2009
    #3
  4. Joltin

    Joltin Notebook Enthusiast

    Reputations:
    0
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    5
    Well, I guess it's not quite that simple then.
    A Google search revealed that there are two different ways of doing this in Vista.

    Simple:
    Open document 1 by double-clicking it
    Launch a new instance of Excel then File|Open the 2nd file etc

    Advanced: (Reg Edit)(Not DDE in Excel)
    Backup the reg keys before making changes.
    http://www.howtogeek.com/forum/topic/open-spreadsheets-in-completely-separate-windows

    Hope that helps.
     
    Joltin, Jan 15, 2009
    #4