Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Running 2 instances of Excel 03 (XL2003)

    I have dual monitors and would like to run two instances of Excel 2003 at once. Is there a way to circumvent the issue noted in the dialog? I'd like for each instance of Excel to be fully functional. I know I can run 07 and 03 at the same time, but that's not what I'm after. Personal.xls is filled with UDF's and the code that drives most of my sheets. I would need it to be available for both instances of Excel [if that's possible].

    Thanks,
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Attached Images Attached Images
    - Ricky

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

    Re: Running 2 instances of Excel 03 (XL2003)

    Running two separate instances of Excel has serious disadvantages:
    - It takes up a lot of extra resources.
    - If you copy something in one instance and paste it into the other, Excel treats it as if you're pasting from another application, so many features that are available while copying/pasting within Excel are disabled.

    You can stretch the Excel application window to cover both monitors and arrange two spreadsheets so that each is displayed on its own monitor - see Using Excel With Multiple Monitors.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Running 2 instances of Excel 03 (XL2003)

    I agree totally with Hans, but you can get around the issue with Personal.xls by setting its IsAddin property to True. But then, unless you have menus to run your macros, they will not appear in the Macros dialog (though you can still run them by typing in the name and pressing enter)
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Running 2 instances of Excel 03 (XL2003)

    Thanks to both of you.
    I will take the advice and not run two separate instances of Excel.

    I've been stretching Excel across the two monitors and then using "Arrange...". It works great in that it will place two open sheets perfectly on the two monitors.

    The reasoning behind my request is that if I am working on one sheet, and double click an additional Excel file, it always attempts to open a fresh instance of Excel, anyway. My only workaround for this is to use the "Open..." command within Excel and needle over to the additional file.
    - Ricky

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

    Re: Running 2 instances of Excel 03 (XL2003)

    If you double-click an Excel workbook in Windows Explorer, it should be opened in the running instance of Excel, not in a new one.

    First, check that Excel is not set to ignore external commands:
    - Select Tools | Options...
    - Activate the General tab.
    - Make sure that the check box labeled "Ignore other applications" is clear.

    If that doesn't help, try the following:
    - Quit all instances of Excel.
    - Select Start | Run...
    - Type <code>"C:Program FilesMicrosoft OfficeOffice11Excel.exe" /regserver</code>
    - Press Enter or click OK.
    - This should re-create the file associations for Excel (and some other settings).

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Running 2 instances of Excel 03 (XL2003)

    I checked the first recommendation. It was as it should be.
    I'll try the other fix a little later this evening. I'll let you know how it goes.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

Posting Permissions

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