Results 1 to 4 of 4

How to open two excel sessions independently of each other

This is a discussion on How to open two excel sessions independently of each other within the Excel Questions forums, part of the Question Forums category; Folks, I need to find out if there is a way to open a new excel session independently from the ...

  1. #1
    Board Regular
    Join Date
    Feb 2008
    Posts
    300

    Default How to open two excel sessions independently of each other

    Folks,

    I need to find out if there is a way to open a new excel session independently from the existing session.

    Let's say I have "Book1" file currently open. Now I open another file namely "Book2". Although, the "Book2" opens up but I don't see it until I go into excel window menu----go at the bottom --- and there I see options for both files i.e. "Book1" &"Book2". So, everytime I need to swith back and forth between these two files, I have to go window menu and from there choose which file I need to work with. In addition, if I do ALT+TAB to switch between Book1 & Book2, it does not work.

    So basically, I need to find out how can I open both files i.e. Book1 & Book2 such that Both files are visible on the Window STATUS Bar ( the bar right next to "START" button on windows). This way I can easily clik on any of the file I need to open. Or else I can use ALT+TAB to switch between any of the files. Currently, I don't see files visible on my status bar and I have to go to window menu to select the file I want.

    Does anybody know how to fix this issue.

    Thanks.

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    10,045

    Default Re: How to open two excel sessions independently of each other

    Open Excel twice and then open Book 1 in one Excel and Book 2 in the other.
    Then go to the desktop toolbar and right click.
    Select tile windows vertically and the two versions should be side by side.

    Regards
    Michael M
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    work 2003, Home 2007

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    Board Regular
    Join Date
    Feb 2008
    Posts
    300

    Default Re: How to open two excel sessions independently of each other

    Michael,

    I was able to get it done by going into Tools--Options--View --clik on Windows Task bar.

    What you have listed below gave me two workbooks side by side. However, I was looking to have it shown separately on the window task bar.

    But I still appreciate your help.

  4. #4
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    Western NSW
    Posts
    10,045

    Default Re: How to open two excel sessions independently of each other

    Glad to hear you got it working the way you wanted.
    Thanks for the feedback anyway.

    Regards
    Michael M
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    work 2003, Home 2007

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com