Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, Australia, Australia
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open Excel in new window (2000sp3)

    Now that I have my nice dual-monitor PC, I would like to be able to look at two worksheets at once. How can I open a second workbook in a different window?

    I've discovered that I can open a second instance of Excel with the /n command, and then open my second file into this. I would like to do this in one step (eg have 'open in new window' as an option when I right-click on a file). Using the /n option in the filetypes setup doesn't seem to work.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Open Excel in new window (2000sp3)

    What happens if you tick "Windows in Taskbar" in the View tab of Tools | Options...? Workbooks should open in separate application windows (although only one instance of Excel is running)

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, Australia, Australia
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open Excel in new window (2000sp3)

    No. That doesn't make the workbooks open in separate windows.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Open Excel in new window (2000sp3)

    Oops, you're correct. Word does that, but not Excel.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Open Excel in new window (2000sp3)

    The following works for Excel 2002:
    - Start Windows Explorer.
    - Select Tools | Folder Options...
    - Activate the File Types tab.
    - Select XLS / Microsoft Excel Worksheet.
    - Click Edit (in Windows 2000 or earlier) or Advanced (in Windows XP or later)
    - Click New...
    - Enter Open in new window in the Action box.
    - Enter "C:Program FilesMicrosoft OfficeOfficeEXCEL.EXE" "%1" in the Application box.
    - Leave the Use DDE check box clear (Windows may check the box later).
    - OK your way out.
    This will add an item to the right-click menu.

  6. #6
    Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, Australia, Australia
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open Excel in new window (2000sp3)

    Perfect. Just what I wanted.
    Thanks.

  7. #7
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open Excel in new window (2000sp3)

    Dual monitors are so handy, aren't they? I use MaxiVista, http://www.maxivista.com/ to place windows on the monitor I want to use. This is a software solution w/o having to buy video cards and so far works great. I like using the second monitor to show windows/programs that I want to reference but not want to constantly bring to the top of the stack to view on my primary PC while I'm working on something else. It sounds like your setup is the 'regular' hardware version with two monitors and two video cards in one PC? I've seen those double monitors that are like two side-by-side LCDs stuck together.

    Deb

  8. #8
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Open Excel in new window (2000sp3)

    Hi Deb
    Thanks for sharing this. I have been looking for exactly this capability for some time now.
    Regards
    Don

  9. #9
    Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, Australia, Australia
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open Excel in new window (2000sp3)

    My setup is hardware-based. A single video card with two video outputs (ATI Radeo X600) and with two 19inch LCD monitors (rotated). Works a charm (though my seti at home screen saver doesn't work).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •