11 July, 2009

The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document.

One of the user from my project reported that he was not able to edit as well as check out the office documents. When i tried to follow the same procedure (i.e. Edit, check-in, check-out) and strange thing was me also got the same error message. When i started my troubleshooting, I found out user created document library with multiple nested folders.

When we go to third or fourth level of the folder and try to edit any file with office application, we are getting an error – The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document. However if we try to edit the document uploaded on the root of the document library, we can edit it properly.

I tried reproduced the issue 2-3 times and found out one common thing and that is: You cannot edit the office document once the URL path reaches characters limit 340. You can edit the documents only till URL path length is up to 339 characters. You can open the documents, you can upload documents but you can't edit them by right click on document and click on "edit in Microsoft Word". Even this behavior is same with non-office documents also like text documents.

Workaround:
The only workaround possible is - open the file directly from the folder, modify and save it as a new file. Every time you need to save it as a new file. It won’t allow to save in the existing file. Or, Move the file one level up and you will be able to do all the operations like edit, check-in and check-out too.


I hope the above information helps you to resolve your problem and time also!! Thanks!!

48 comments:

  1. I had the same problem. And Amol, you are on the dot. Thanks very much for the pointer. However, I guess MS has to fix the problem ground up.

    cheers

    ReplyDelete
  2. Cheers Buddy. It did resolve my issue . Thanks

    Zoeb

    ReplyDelete
  3. What about if the file is in PDF or other format ?

    How can we open the files then ?

    ReplyDelete
  4. PDF files are not supported by sharepoint as they can be used to view only by means of sp-site.

    As the office,excel as well as powerpoint belongs to Microsoft office product and that's why they are supported becuase office integrates with the sharepoint directly and not the adobe's PDF !!

    In terms of other extenions, you can store them on your sp-site but in read only mode as you will not get the best performance just like you will get from office docs !!

    Please let me know if you any queries or questions regarding the same !! Thanks !!

    ReplyDelete
  5. Hi Amol,

    I found this error in a different context.
    The error is "The document could not be opened for editing. A Microsoft Sharepoint Foundation compatible application could not be found to edit the document. "

    Context:
    SP 2010
    Created custom pagelayout in SPD from my custom contenttype. Deployed the solution. could see pagelayout in the gallery. When tried to create a new page, the pagelayout doesn't display at all.I mean it doesn't display anything not even default pagelayouts in the gallery.
    Any thoughts?

    ReplyDelete
  6. Hello Amol...

    Thanks for your post. Do you know if this issue (with 340 character limit in document URL) has been resolved in SP 2010?

    regards,
    Gopal Kamat

    ReplyDelete
  7. Here is your answer:

    The max length for the "path" part of the URL is unchanged from 2007 and basically the same as for local drives. 260 or so... The rest of the URL after "?" is generally not an issue.

    > doc library name length

    More of a limitation of the total URL path as noted above. But here's a good trick to know: When you create a list or library, give a short name "TM" and then go back and rename it to something more useful "Training Materials and Sample Files". The creation name is used in the URL and is not changed when you rename a list/library.

    > max length of a folder name

    123 characters, but more of a limitation of the total URL path as noted above, and there is no "rename" trick to create a short URL. Try to keep these short. If you need to add metadata don't add it to the folder name, instead create a new folder content type with metadata.


    Imp Links:

    http://technet.microsoft.com/en-us/library/ff919564.aspx

    http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spsite.maxfullurllength.aspx

    ReplyDelete
  8. Hi Amol,

    Thanks so much for your tips. I am having the same issue.However, it would only occur if I have the "check out required " on , as soon as I turn it off. Everything is working fine !!!!

    I have tried everything suggested from the MS KB. But still no luck.

    Do you have any idea? BTW, I am running SP 3.0 with office 2007 on XP

    cheers,
    Danny

    ReplyDelete
  9. Is this happening only on one machine ? / Multile machines are having the same issue ?

    Could you please check and let me know ?

    One more thing-Could you please run the the Office diagnosotic Tool ?

    which explorer you are using when you faced this issue ? If you are using IE 6.0 then could you please test with IE 7 ?

    Please check and let me know, Thanks..

    ReplyDelete
  10. I came across this website and saw that you had a similar issue.

    So, I get the same error from a user using Windows 7 and this error pops up for all types of office exts. but when I try to edit any document it lets me open, edit and save back into SharePoint. Currently she uses IE 8.

    Any ideas why this could be happening or how I can fix it?

    Most of the users currently use XP could WIN7 be the issue?

    I'd appreciate any help!
    Thanks,
    Claudia

    ReplyDelete
  11. -What zone is Internet Explorer detecting the web site as (bottom right of your web browser window). Ensure that it is in the Intranet or Trusted Sites zone

    If not then please follow these steps:

    1. Open Internet Explorer and go to Tools-Internet Options-Security.
    2. Click the "Security" tab and choose the "Trusted Sites" icon.
    3. Then click on the button "Sites". A window will open, where you can add any sites that you wish to be in the Trusted zone. Be sure to remove the check by the entry "Require server verification (https:)...."
    4. Enter the site of interest in the line provided. Site URLs can be typed in directly or entered by copying and pasting.
    5. The site is now added to the list of trusted sites.

    -Does that user is getting this error message/popups at the root of the document library ?

    -Does that file is present inside the nested folders ?

    -If that user is getting the error message at the root of the document library too then please include the option 'windows sharepoint services'compatible application by means of office..

    If Office 2003 is installed on the computer, follow these steps:

    -Click Start, and then click Control Panel.
    -Click Add or Remove Programs.
    -In the list of currently installed programs, click Microsoft Office 2003, and then click Change.
    -Click Add or Remove Features, and then click Next.
    -Click to select the Choose advanced customization of application check box, and then click Next.
    -In the Choose update options for applications and tools box, expand Office Tools, click the down arrow next to Windows SharePoint Services Support, and then click Run from My Computer.
    -Click Update.

    If a 2007 Office suite is installed on the computer, follow these steps:

    -Click Start, and then click Control Panel.
    -Click Add or Remove Programs.
    -In the list of currently installed programs, click Microsoft Office suite 2007, and then click Change.
    -Click Add or Remove Features, and then click Continue.
    -Expand Office Tools.
    -Click the down arrow next to Windows SharePoint Services Support, and then click Run from My Computer.
    -Click Continue.

    If you have any queries/questions regarding the above mentioned info then please let me know..Thanks for your patience...

    ReplyDelete
  12. Hello mol Ghuge,

    I have a similar problem with it.

    I have a wss3.0 site using form authenticate.

    On client PC, if it installed office 2003 already, I remove office 2003 & install office 2007. ===> It could not open document in edit mode. Just open office without anything.

    If client PC did not installed office 2003, I install office 2007 & everything is ok.

    Could you help me the problem on PCC that installed office 2003 already?

    Thank you so much
    Snow Rain

    ReplyDelete
  13. lets do these steps:

    The machine which is having office 2003, Go for the Upgrade so that you don't have to remove office 2003.

    few more things:

    Is this problem faced by one user/multiple user ?

    Is this happening only on some machine or all machines ?

    Please mentioned the complete URL of the document library where the users are facing the problem...

    Asking URL-Need to check the character limitation problem..so that we can try at the root of the document library

    Few more things before we can go for upgrade:

    Try these one:

    -Click Start, and then click Control Panel.
    -Click Add or Remove Programs.
    -In the list of currently installed programs, click Microsoft Office 2003, and then click Change.
    -Click Add or Remove Features, and then click Next.
    -Click to select the Choose advanced customization of application check box, and then click Next.
    -In the Choose update options for applications and tools box, expand Office Tools, click the down arrow next to Windows SharePoint Services Support, and then click Run from My Computer.
    -Click Update.

    Please check and let me know in case of any issues,Thanks for your patience...

    ReplyDelete
  14. Hello Amol,

    Thanks for your reply.
    This problem faced by any users that logged on to my site.
    It happens only on some PC that I installed office 2003.

    Right now, I installed office 2007 already. By the way, when i opening document (.docx) as Edit in Microsoft Office Word, the word application is opened but the screen for log-in does not display, and document file can not be opened, also. If i try to open that document file, it display message "could not open file "http:// .../abc.docx".

    If I open document normally, document is opened with read-only mode.

    I have tried un-selected "Windows SharePoint Services Support" => update and then Re- select it => update but same problems.

    Is there any idea about that?

    Thanks for your support.
    Snow

    ReplyDelete
  15. it is surely a machine specific issue and not from the SharePoint side.

    Can we try this workaround only for those machine which are facing this problem: Try to check out the file and go to the location: "my documents/sharepoint draft" and try to open the file, make some changes and try to save it..

    check the results and let me know...

    2. Please run the diagnostic too

    To run the Microsoft Office Diagnostics feature from a 2007 Office program, follow these steps:
    Start the Office Diagnostics tool. To do this, use either of the following methods:
    For a menu-based 2007 Office program, click Office Diagnostics on the Help menu.
    For a ribbon-based 2007 Office program, follow these steps:
    Click the Microsoft Office Button, and then click Program Options.

    Note In this option, Program represents the name of the program.
    In the Navigation Pane, click Resource.
    Click Diagnose.
    Click Continue.
    Click Start Diagnostics.

    ReplyDelete
  16. Thanks so much!

    The problems are fixed when I update office with these files:
    office2007-kb967642-fullfile-x86-glb.exe office2007sp2-kb953195-fullfile-en-us.exe

    Best Regards,
    Snow

    ReplyDelete
  17. Hi Amol,

    One of the user had same problem when she try to
    edit excel document in sharepoint getting this error "A Windows SharePoint Services compatible application could not be found to edit the document".

    I had a net meeting with user and found that she has office 2003 basic edition and tried the above workoround ie

    Click Start, and then click Control Panel.
    -Click Add or Remove Programs.
    -In the list of currently installed programs, click Microsoft Office 2003, and then click Change.
    -Click Add or Remove Features, and then click Next.
    -Click to select the Choose advanced customization of application check box, and then click Next.
    -In the Choose update options for applications and tools box, expand Office Tools, click the down arrow next to Windows SharePoint Services Support, and then click Run from My Computer.
    -Click Update.

    It seems the user system does not have admin privileges as When I select office 2003, I did n't see change button.

    Is there any other way I can resolve this issue?

    ReplyDelete
  18. Hello Kumar,

    If the user don't have rights on her machine then please involve the desktop support team in this issue so that they can execute the above mentioned steps. Lets the helpdesk/Desktop Support Team troubleshoot the issue and please let me know the progress.. Feel free to ask any kind of queries/questions, Thanks for your patience..

    ReplyDelete
  19. Hi Amol,

    Thank you for your kind attention on this issue.I forwarded to Desktop support team with above instructions to implemen in user machine.But today the user reported the issue was not still resolved as she is getting the same error.

    Can you please suggest me is there any work arount for this?

    ReplyDelete
  20. Hello Kumar,

    If the above mentioned steps has already been implemented by the desktop support team then could you please check the following sections and get back to me ?

    1. are you able to edit those excel documents that user is trying to edit by using the same method i.e. (Excel Document-->Edit in Microsoft Excel)

    2. Does the user tested on any other machine ? so that it will be clear that it is machine specific or SharePoint specific ?

    3. Which explorer is in used by the user ? If you are able to edit and user is not then what is difference between your machine and user machine ? Please point out the differences

    4. The document library in which the user is trying to edit excel documents-Is this only document library is having the problem ? If Yes then if we go one step before to that document library which is having the short URL ? Example: http://SharePointwebsite/sites/Test1/Shared Documents

    So that we can conclude the problem is with the URL limitation

    5. Which office version is installed on user machine ? If it is office 2003 then make sure the user is trying to edit Office 2003 docs only and not Office 2007 docs

    6. Make sure two office versions should not be installed on the same machine i.e. core office 2003 and some office 2007 components

    Please check the above recommendations and let me know the results, Thanks for your patience..

    ReplyDelete
  21. Thank you for the quick response, will get back to you soon on the above recommendations.

    ReplyDelete
  22. Another solution that I found , in IE disable the sharepoint add-ons and enable them back and restart the browser. Worked like a charm .
    Most of the solutions did not work for me.

    ReplyDelete
    Replies
    1. Thank you for the valuable feedback by means of alternate solution! This will be definitely useful for all the SharePoint communities!!!

      Delete
  23. thanks 4 sharing the information, this will be definately useful to the sharepoint users across the whole world, Thanks again :-) :-)

    ReplyDelete
  24. Hi Amol,

    Thank you for some useful information here.

    I have the same issue when I can not open documents from the sharepoint in edit mode. It only opens in read only (and says in bracket locked by another user for editing) even when I check out the doc. I see above sometimes nested URL's can cause this problem. However, other users do not face the issue.
    Please note I have all access rights set up by admin.
    Thanks and Regards
    Amy

    ReplyDelete
  25. Hi Amol,
    Need urgent help
    I am unable to Checkout any file present in library for MOSS 2007 whether it be PDF,Word,Excel.Also i can open ,edit Excel,Word but cant open PDF.
    Thanks

    ReplyDelete
    Replies
    1. are you getting any error message?

      what kind of permissions you have? i m suspecting that this is happening becoz of permissions.

      other possibility with respect to permissions: you might have permissions at the site level but not having enough rights to modify the docs at the library level.....

      Delete
  26. If yοu want to get a great deal from
    this ρost thеn you haѵe to apply suсh methods to your ωon web sіte.


    my weblog: supplement

    ReplyDelete
  27. Hi Amol,

    I understood and partially agree to the blog as I've full-control on the Web-app level and I have given full-control to a user for a site-collection. I can access any site and able to open all the documents but this user is not able to open the documents which are 3-4 levels down in doc-lib and get the popup saying "The document could not be opened for editing. A Microsoft SharePoint Foundation compatible application could not be found to edit the document.". Can you please suggest any solution here.

    Thanks in Adv.

    ReplyDelete
    Replies
    1. make sure that the office application should be installed on the machine where he is facing the problem.

      This is pretty much happening because of limitation only as i mentioned above in my article and its not a problem of permissions or access.

      Just to isolate the problem, as it can be machine specific also

      tell that user to login to different machine by using his ID and check the results/ check on somebody's machine to login to the SharePoint site by using his credentials - SIGN IN AS DIFFERENT USER option

      we can also check which office version he is using? is it different from yours that is installed?

      if yes then we can match the same, otherwise, we can try to repair the office and check the results.

      Please check the above suggestions and let me know in case of any queries, Thanks for your patience.

      Delete
  28. Thank you for this valuable info!

    ReplyDelete
  29. It is not my first time to pay a quick visit this web site, i am browsing this web
    page dailly and obtain nice data from here every day.


    Also visit my blog post; online business management school

    ReplyDelete
  30. Our accuracy and data precision proves beneficial in terms of pricing and time management that assist the consultants in meeting their objectives in a cost-effective and timely manner.
    Lipstick color mixtures are added to wax, such as candellila, bees
    wax, and paraffin, just like a crayon, which is color pigment mixed with hot paraffin
    before cooled. It is not real if any of the products
    they are selling, such as eye shadow or pigments have a NUMBER instead of an
    actual product name.

    Feel free to surf to my web site - my pham 123vn

    ReplyDelete
  31. Way cool! Some extremely valid points! I appreciate
    you penning this article and the rest of the site is also really
    good.

    Have a look at my web blog - Axl Hazarika

    ReplyDelete
  32. Simply wish to say your article is as astonishing.
    The clarity in your post is just excellent and i can assume you are an expert on this
    subject. Well with your permission allow me to grab your feed to keep up to date with forthcoming post.
    Thanks a million and please carry on the enjoyable work.

    My page; psn gratuit

    ReplyDelete
  33. Il me tаrdе de liгe &X6C;e prochain poste

    Also vi&X73;іt my webs&X69;te; Gourmande Femme Mature

    ReplyDelete
  34. Est-i&X6C;pοѕsible de vo&X75;s pi&X71;uer
    certaines lig&X6e;eѕ ѕur m&X6F;n sіte pеrѕоnnel ?



    Als&X6f; νisit my ωeb blog; Travesti Fгipouill&X65; (Www.Streaming-Trans.Eu)

    ReplyDelete
  35. It's a shame you don't have a donate button! I'd certainly donate to
    this fantastic blog! I suppose for now i'll settle
    for bookmarking and adding your RSS feed to my Google account.
    I look forward to new updates and will share this site with my Facebook group.
    Chat soon!

    Here is my site :: spilleautomater til salgs

    ReplyDelete
  36. Det er en premisser for innhold og teste gratis spilleautomater denne nettutgaven
    virkelig bare kan bestemme riktig ut hele studioproduserte album må du også
    være enn seriøse dyr. Velg komme til siden brannmann enn millioner
    kroner dagen skjønner noe make html spill
    eller bare rett kasinoenehovedsak bestar avspille kortspill
    ytterligere innsatser erkjent.

    My web-site ... norske spilleautomater

    ReplyDelete
  37. It can be really difficult finding a decent SEO business
    nowadays, just going to do it myself I think

    ReplyDelete
  38. Emile le téléphone la moyenne son centre toit.

    Dans ces cas video surveillance montrant la maison de haute performance énergétique.
    Autant dire que eau et pompe solaire particuliers.


    Visit my webpage ... porte de garage enroulable prix

    ReplyDelete
  39. Definitely believe that which you said. Your favorite justification seemed to be
    on the internet the easiest thing to be aware of. I say to you,
    I definitely get irked while people consider worries that they
    just don't know about. You managed to hit the nail upon the top and also defined
    out the whole thing without having side-effects , people
    could take a signal. Will likely be back to get more.

    Thanks

    Look at my web page; wedding cake topper ()

    ReplyDelete
  40. Hi Amol,
    At the outset would like to thanks for sharing your knowledge. I have noticed that almost all of your blog items are having more than a page comments.. which will help readers to recall all the possibilities of issues and solutions, Same will indicates the popularity and frequent usage of your blog. Indeed, you are harvesting real knowledge. Keep up the momentum!!

    ReplyDelete
    Replies
    1. Thank you so much for your kind words and wonderful comment! Its really my pleasure that my knowledge is helping people to get the insight that they are looking for! Thanks a TON once again :)

      Delete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge