Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    opening files via windows explorer (XP 5.1)

    Hi there

    I have recently installed a new machine with XP and office 97.

    When we open an excel file via explorer we get an error saying that the file is already open, and that we cannot open the same file name twice. Pressing OK then opens the file without any apparent problems.

    Opening the same file directly from Excel opens the file with no problems.

    1. Is this an Excel or Windows problem?
    2. How to fix?

  2. #2
    Silver Lounger
    Join Date
    Apr 2001
    Location
    New York, New York, USA
    Posts
    2,328
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: opening files via windows explorer (XP 5.1)

    I didn't use Office97 for a couple of years, but as long as I remember it's a problem with file association settings.

    Open Windows Explorer (or My Computer), click Tools | Folder Options, then File Types tab, scroll down to XLS - Microsoft Excel Worksheet, highlight it, click Advanced button, highlight Open action and click Edit button.
    Make sure that the path in "Application used..." box is in double quotes, along with %1 switch, like this:

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" "%1"

    or, if DDE is used instead of %1 switch, the following message is in DDE box:

    [open("%1")]

    and the word Excel is in Application box.

  3. #3
    Lounger
    Join Date
    Nov 2001
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: opening files via windows explorer (XP 5.1)

    Hi thanks for the advice.

    I went to the screen you advised me to and it already looks like what you describe. See attached.

    When I have Excel open, or open from Excel I do not get the error. When I do not have the application running I do get the error.

    Ian
    Attached Files Attached Files

Posting Permissions

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