Excel "file is already open"

Discussion in 'Microsoft Excel Misc' started by John McFadden, Jul 14, 2003.

  1. Whenever I open a '.xls' workbook from outside Excel
    (such as from Windows Explorer), Excel indicates that the
    file is already open - although, once I click OK, I seem
    to be able to work with the file normally. The same file
    will open fine from within Excel. I am using Excel 97 on
    an XP-Home machine.

    Can you explain why I may be getting this message, and
    how I might correct for it?
     
    John McFadden, Jul 14, 2003
    #1
    1. Advertisements

  2. The FAQ at Debra Dalgleish's site might give the solution:

    http://www.contextures.com/xlfaqApp.html#AlreadyOpen

    John McFadden wrote:
    >
    > Whenever I open a '.xls' workbook from outside Excel
    > (such as from Windows Explorer), Excel indicates that the
    > file is already open - although, once I click OK, I seem
    > to be able to work with the file normally. The same file
    > will open fine from within Excel. I am using Excel 97 on
    > an XP-Home machine.
    >
    > Can you explain why I may be getting this message, and
    > how I might correct for it?


    --

    Dave Peterson
     
    Dave Peterson, Jul 14, 2003
    #2
    1. Advertisements

  3. John McFadden

    Tom Ogilvy Guest

    with excel open, go to tools=>Options=>General and make sure Ignore Other
    Applications is not checked.

    if that doesn't help with the opening, close excel, go to the windows start
    menu and select run (it is in the right column of choices at the bottom on
    my version of win -xp)

    enter

    Excel.Exe /regserver

    and click OK.

    This will reset Excel's registry settings.


    Regards,
    Tom Ogilvy


    John McFadden <> wrote in message
    news:033201c349a3$ea037d60$...
    > Whenever I open a '.xls' workbook from outside Excel
    > (such as from Windows Explorer), Excel indicates that the
    > file is already open - although, once I click OK, I seem
    > to be able to work with the file normally. The same file
    > will open fine from within Excel. I am using Excel 97 on
    > an XP-Home machine.
    >
    > Can you explain why I may be getting this message, and
    > how I might correct for it?
     
    Tom Ogilvy, Jul 14, 2003
    #3

  4. >-----Original Message-----
    >The FAQ at Debra Dalgleish's site might give the

    solution:
    >
    >http://www.contextures.com/xlfaqApp.html#AlreadyOpen
    >
    >John McFadden wrote:
    >>
    >> Whenever I open a '.xls' workbook from outside Excel
    >> (such as from Windows Explorer), Excel indicates that

    the
    >> file is already open - although, once I click OK, I

    seem
    >> to be able to work with the file normally. The same

    file
    >> will open fine from within Excel. I am using Excel 97

    on
    >> an XP-Home machine.
    >>
    >> Can you explain why I may be getting this message, and
    >> how I might correct for it?

    >
    >--
    >
    >Dave Peterson
    >
    >.
    >

    Thanks, Dave,
    The FAQ info worked like a charm.

    John
     
    John McFadden, Jul 15, 2003
    #4

  5. >-----Original Message-----
    >with excel open, go to tools=>Options=>General and make

    sure Ignore Other
    >Applications is not checked.
    >
    >if that doesn't help with the opening, close excel, go

    to the windows start
    >menu and select run (it is in the right column of

    choices at the bottom on
    >my version of win -xp)
    >
    >enter
    >
    >Excel.Exe /regserver
    >
    >and click OK.
    >
    >This will reset Excel's registry settings.
    >
    >
    >Regards,
    >Tom Ogilvy
    >
    >
    >John McFadden <> wrote in message
    >news:033201c349a3$ea037d60$...
    >> Whenever I open a '.xls' workbook from outside Excel
    >> (such as from Windows Explorer), Excel indicates that

    the
    >> file is already open - although, once I click OK, I

    seem
    >> to be able to work with the file normally. The same

    file
    >> will open fine from within Excel. I am using Excel 97

    on
    >> an XP-Home machine.
    >>
    >> Can you explain why I may be getting this message, and
    >> how I might correct for it?

    >
    >
    >.
    >

    Thanks, Tom,

    EXCEL /REGSERVER did the trick.

    John
     
    John McFadden, Jul 15, 2003
    #5
  6. John McFadden

    Kri' sis

    Joined:
    Nov 16, 2008
    Messages:
    1
    Likes Received:
    0
    Hi,

    The information from that link from Debra Dalgleish was immediately helpful. I was having the exact same problem as John when using Excel 97 on an XP home computer. Thank you, PCReview, for keeping this post/thread readable to the public for the past 5+ years.

    -Kri' sis
     
    Kri' sis, Nov 16, 2008
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Eric Mata
    Replies:
    0
    Views:
    420
    Eric Mata
    Jul 18, 2003
  2. boomer4d

    Re: Excel file won't open unless Excel is already open

    boomer4d, Dec 3, 2003, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    555
    boomer4d
    Dec 3, 2003
  3. Doug
    Replies:
    2
    Views:
    296
  4. Guest
    Replies:
    1
    Views:
    284
    Guest
    May 19, 2006
  5. Guest

    Cannot open excel file when another is already open

    Guest, Jun 18, 2007, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    186
    Guest
    Jun 18, 2007
Loading...

Share This Page