Results 1 to 11 of 11
  1. #1
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Opening worksheets (Excel 2003 SP2)

    Using Windows Explorer to open Excel worksheets has always worked fine. I would double click the file I wanted to open and it would open. This method still works for Word, Power Point , and Access documents. It does not any longer open Excel worksheets. Any ideas on what is wrong and how to correct it.

    These same files open perfectly if I first open Excel and then use Excel itself to open the file.

    I have tried re registering it and that didn't help.
    H Lewton

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Opening worksheets (Excel 2003 SP2)

    Do any of the suggestions in File association problem (XP) help?

    Steve

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

    Re: Opening worksheets (Excel 2003 SP2)

    You didn't say what happens when you double click on a workbook, so it is tough to guess which of the several possible problems could be causing this. As a first guess, copy the line below, and then select Run from your Start menu. Paste the line below into the Run box (you may have to adjust the path to your copy of Excel.exe), and press enter. After Excel starts, close it down again and try double clicking on a workbook.

    <code>
    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /Regserver
    </code>
    Legare Coleman

  4. #4
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Opening worksheets (Excel 2003 SP2)

    I already ran that command before I posted. It didn't help.

    When I double click on a workbook, Excel opens but it has no workbook showing. It is just blank with no grid line or anything.
    H Lewton

  5. #5
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Opening worksheets (Excel 2003 SP2)

    sdcjapr,

    Yes one of Hans's suggestions worked.

    Many thanks.
    H Lewton

  6. #6
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Opening worksheets (Excel 2003 SP2)

    This is Hans's suggestion that worked:
    In addition to Steve's suggestion, make sure that the "Ignore Other Applications" check box in the General tab of Tools | Options... is NOT checked. If it is, you won't be able to open workbooks from Explorer, although you can still open them from within Excel.

    Regards,
    Hans


    What I would like to know now is how would "Ignore Other Applications" check box in the General tab of Tools have gotten checked in the first place. One day my method was working perfectly and then the next day it developed the problem I described. I did not make the change to "Ignore Other Applications" check box in the General tab of Tools, I didn't even know the option existed.

    Thanks.
    H Lewton

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

    Re: Opening worksheets (Excel 2003 SP2)

    My guess would be that you changed it without realizing that you had changed it, or someone else changed it for you. It is also possible (though rather unlikely) that you opened a workbook that ran some VBA code that changed it.
    Legare Coleman

  8. #8
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Opening worksheets (Excel 2003 SP2)

    LegareColeman,

    Thanks for the suggestions but I did neither. I do keep close track of any changes I make and no one else uses that machine.

    The only thing I did that may have caused it (but it didn't on 4 other machines) was to get all 9 or 10 of Microsoft's security patches. None of them asked for any of my input except to reboot. Believe me no code was run and I did not make the change manually.
    H Lewton

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

    Re: Opening worksheets (Excel 2003 SP2)

    This is one of those things that can't be explained. It just seems to happen from time to time... <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

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

    Re: Opening worksheets (Excel 2003 SP2)

    Then maybe a solar flare cause that bit to flip on your hard disk.
    Legare Coleman

  11. #11
    Silver Lounger
    Join Date
    Aug 2001
    Location
    Canton, Ohio, USA
    Posts
    1,716
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Opening worksheets (Excel 2003 SP2)

    Hans thanks. I know I didn't make any changes and never would have thought to look there except for directions in your post. And the only Excel worksheets I open or use are made by me. The same goes for Word and Access documents. I do occasionally open a Power Point presentation that comes to me in an email but not on that machine. It is a lap top and I use it sparingly.
    H Lewton

Posting Permissions

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