locked
Excel files try to open in Word when using SPS 2003 RRS feed

  • Question

  • I am using Excel (Office) 2003 and SharePoint 2003.

    I am experiencing an odd bug.  If I click an Excel file in SharePoint, it opens read-only in Excel, as expected.  If I use the drop down and choose Edit in Microsoft Office Excel, then the file tries to open in Word instead of Excel - which does not work, of course.

    If I close all instances of Excel before trying to open from SharePoint into Excel, then it does work.  The bug only shows up when I have other instances of Excel open.

    Opening Excel files from websites that are not SharePoint works as expected.  This issue only occurs with Excel files stored on SharePoint.

    PowerPoint files open properly - the problem only occurs for Excel files.

    Immediately upon choosing the Edit in Microsoft Office Excel menu item, I get the error below and then the document tries to open in Word.

    ---------------------------
    Message from webpage
    ---------------------------
    The document could not be edited.
    The required application may not be installed properly, or the requested document cannot be opened.

    Please ensure that the necessary application is installed and that the path to the document is correct. If the application was set to install on first use, run the application and then try editing a document again.
    ---------------------------
    OK  
    ---------------------------

    Any suggestions?

    Thanks,

    Dale

    • Edited by Dale2K9 Tuesday, March 8, 2011 4:52 PM Added versions
    • Edited by Mike Walsh FIN Tuesday, March 8, 2011 5:07 PM when using SPS 2003 added to Title. Needed there as SPS 2003 is not default in these forums and many forum users have never used it
    Tuesday, March 8, 2011 4:50 PM

Answers

  • Hi,

    did you try with re installation / repair of office 2003 ?

    If not try that.

    Please let us now results after above testing.


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Dale2K9 Thursday, March 10, 2011 4:07 PM
    Wednesday, March 9, 2011 7:43 AM

All replies

  • Hi,

    did you try with re installation / repair of office 2003 ?

    If not try that.

    Please let us now results after above testing.


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Dale2K9 Thursday, March 10, 2011 4:07 PM
    Wednesday, March 9, 2011 7:43 AM
  • Hi Dale2K9,

    Please ensure the xls file type is registered in Folder Option follow this step:
    Open Explorer > Tools > Folder Options > File Types > Find XSL extension > Advanced. Edit Open action (if there is no this action, you can click New to create it) > Type &Open in Action box > "C:\Program Files\Microsoft Office\Office11\EXCEL.EXE" /e in Application used to perform action > select Use DDE > [open(“%1”)] in DDE Message > Excel in Application > keep blank in DDE App Not Running > system in Topic.

    Best regards,
    Emir

    Thursday, March 10, 2011 7:54 AM
  • Emir, I have checked the file type registration and it is correct according to what you suggested.  This was what I expected because I can double-click an Excel file in Explorer and it opens properly and, if I don't have any other Excel files open, it works from SharePoint.

    Pratik, I performed the Detect and Repair procedure under the help menu.  That fixed it.  Thank you.

     

    Thursday, March 10, 2011 4:08 PM