+ Post New Thread
Results 1 to 14 of 14
Office Software Thread, Multiple Excel Windows? in Technical; I've looked all around the interweb for this and tried a couple of solutions that all fail. What I want ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0

    Multiple Excel Windows?

    I've looked all around the interweb for this and tried a couple of solutions that all fail. What I want is a separate Window for each Excel workbook. I can't seem to find any way of making this happen. Anyone know if it's possible, and if so, how?

  2. #2
    jstuttard's Avatar
    Join Date
    Nov 2009
    Location
    Northamptonshire
    Posts
    146
    Thank Post
    8
    Thanked 29 Times in 23 Posts
    Rep Power
    14
    the only way I manage this is to open seperate instances of Excel, then use the open dialog within each instance. but its a pain

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    As above, or make the master Excel window span your whole multi-screen workspace, and hit the maximise button on each workbook (i think it's called Restore when you do that) then you can change the size and lay them out next to each other within the master Excel. A pain, but doable. Also if you minimise them, they line up along the bottom like windows apps do.

  4. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    +1 to @jstuttard although formulae won't see workbooks in other instances of Excel which is irritating

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Quote Originally Posted by LosOjos View Post
    +1 to @jstuttard although formulae won't see workbooks in other instances of Excel which is irritating
    There's a way to refer to other documents though isn't there? So it works even when they are closed?

  6. #6


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,506
    Thank Post
    227
    Thanked 848 Times in 727 Posts
    Rep Power
    287
    i wish i could find a way whats the point oif being able to have multiple sheets open when they are all on top of one another

  7. #7

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Quote Originally Posted by vikpaw View Post
    There's a way to refer to other documents though isn't there? So it works even when they are closed?
    Yeah, but you have to type the entire file name and path - not exactly friendly! Whereas if they are all open in the same instance of Excel (and thus in one window) then you can just click on a cell in any open workbook and Excel automatically does that for you. Only seem to have had this problem since Excel 2007!

  8. #8

    Join Date
    Jan 2007
    Location
    Nottinghamshire
    Posts
    530
    Thank Post
    1
    Thanked 84 Times in 58 Posts
    Rep Power
    38
    amazing excel is still using windows 3.1 window management, oh well, by the next version it'll all be full screen, 1 sheet at a time, on a tablet

  9. #9


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,506
    Thank Post
    227
    Thanked 848 Times in 727 Posts
    Rep Power
    287
    Quote Originally Posted by mavhc View Post
    amazing excel is still using windows 3.1 window management, oh well, by the next version it'll all be full screen, 1 sheet at a time, on a tablet
    as someone else said in sure in 2003 it was fine you could get it to open up a new instance for every sheet 2007/2010 unless you either open excel again then load the doc its one instance. I preume this is to use less ram but if you have multiple monitors its a total pita

  10. #10

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    Quote Originally Posted by mavhc View Post
    amazing excel is still using windows 3.1 window management, oh well, by the next version it'll all be full screen, 1 sheet at a time, on a tablet
    oh so you've seen the Windows 8 developer preview then?

    [NOTE: just kidding, I'm sure the final release will be more desktop friendly!]

  11. #11


    Join Date
    Feb 2007
    Location
    51.405546, -0.510212
    Posts
    8,710
    Thank Post
    220
    Thanked 2,615 Times in 1,926 Posts
    Rep Power
    777
    Quote Originally Posted by Rawns View Post
    What I want is a separate window for each Excel workbook.
    Did you try this...?

    Code:
    EXCEL.exe -p

  12. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Quote Originally Posted by Arthur View Post
    Did you try this...?

    Code:
    EXCEL.exe -p
    Yes, on XP with office 2007. nothing different.

    did no-one like my idea of just making the indivdual sheets smaller within the workspace? In 2007, under the view menu it's got buttons to automatically, tile, side-by-side them too.

  13. #13
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,349
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60
    You have to hold ctrl while opening Excel and it will open in a new window. V V V V useful for screen spanning

  14. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Quote Originally Posted by Jamo View Post
    You have to hold ctrl while opening Excel and it will open in a new window. V V V V useful for screen spanning
    No joy All it does it ask me if i want to open in safe mode then it's the same as before. Opening documents with ctrl is the same. Only way is as said to launch different instances, or make the master instance massive and tile the workbooks within.
    Excel 2007 by the way.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 11th January 2010, 01:42 PM
  2. Replies: 0
    Last Post: 9th December 2009, 01:09 PM
  3. Thin client question... (Multiple users on Windows XP???)
    By fafster in forum Thin Client and Virtual Machines
    Replies: 14
    Last Post: 22nd October 2008, 11:52 AM
  4. Windows XP Explorer Multiple Printing
    By grahamd22 in forum Windows
    Replies: 1
    Last Post: 3rd July 2008, 01:32 PM
  5. Finding out Multiple Windows Keys
    By mmoseley in forum Network and Classroom Management
    Replies: 2
    Last Post: 30th July 2007, 08:14 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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