Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Opening saved file displays error: already open.

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am having a problem with multiple workstations on LAN running Office/Excel 97 under Windows 2000 Pro. When an saved excel doc is opened, an error message is displayed: "A document with the same name is already opened. Please close the document and try again." The user may then proceed normally, with the document open and fully functional. It seems as though Excel is trying to open the file twice? I have tried reinstalling Office 97, copying the registry keys from a working machine to an affected machine, and checking the alternate startup folder to make sure it is blank. Antivirus definitions are also up-to-date. I could not find anything pertaining to this type of problem on Microsoft's knowledge base. Any ideas?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    first re boot (cold boot wait 2 mins and turn back on)

    try what happens


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    you need to go into windows , Run, under the Start menu, and type:

    excel.exe /regserver

    This will force Excel to re-register itself and its components,
    solving the "double opening" file problem.


  4. #4
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for your replies. The /regserver parameter worked great. Not sure what was causing this problem in the first place, but I have since added the fix to the network login script so I'll never hear about it again. :>

Some videos you may like

User Tag List

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
  •