Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Sacramento, California, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Separate Execution? (2000)

    Is there a way to have Excel 2000 behave the way that Word does when opening an existing spreadsheet? Word always opens a separate instance of the program for each document, whereas Excel will open a new window within an existing instance. The problem I have with this approach is that I often (like, always) close Excel when I'm done with a worksheet, and the other Excel windows I'm still working on close also.

    I have found that if I start up Excel from the program menu, I create a separate instance, but this means I would need to remember to do something different than I do with Word.

    Thanks.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Separate Execution? (2000)

    Select Options from the Tools menu. Click on the View tab. Put a check mark next to "Windows in Taskbar."
    Legare Coleman

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

    Re: Separate Execution? (2000)

    Even if Word seems to open a separate instance of the application for each document that you open, this is just an illusion. There is but a single instance of winword.exe in memory. This is true even if you "start" Word several times from the Start | Programs menu (or from the Quick Launch toolbar, or from a desktop shortcut). You can verify this in the Processes tab of the Task Manager. But to the outside world, Word behaves as if each document runs in a separate instance: clicking the Close button in the upper right corner of the application window closes only one document. But if you select File | Quit, ALL open documents will be closed, and in the Window menu, you will see all open documents.

    Excel does not pretend that each workbook is opened in a separate instance of the application. All open workbooks are displayed in a single application window. On the other hand, it IS possible to start multiple instances from the Start | Programs menu (or from the Quick Launch toolbar etc.). If you do so, the Window menu of each instance will only list the workbooks open in that instance, and selecting File | Quit will only close the workbooks open in that instance. You can verify that multiple instances are running in the Processes tab of the Task Manager.

    Running multiple instances of Excel is a drain on resources, so it it not advisable. Moreover, you will run into problems with add-ins and startup files such as Personal.xls. It's best to learn to use the close button of the workbook instead of the close button of the Excel application. You can do the same in Word.

  4. #4
    Lounger
    Join Date
    Nov 2001
    Location
    Sacramento, California, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Separate Execution? (2000)

    Good to know - thanks.

Posting Permissions

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