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!!
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.
ReplyDeletecheers
Cheers Buddy. It did resolve my issue . Thanks
ReplyDeleteZoeb
What about if the file is in PDF or other format ?
ReplyDeleteHow can we open the files then ?
PDF files are not supported by sharepoint as they can be used to view only by means of sp-site.
ReplyDeleteAs 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 !!
Hi Amol,
ReplyDeleteI 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?
Hello Amol...
ReplyDeleteThanks 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
Here is your answer:
ReplyDeleteThe 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
Hi Amol,
ReplyDeleteThanks 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
Is this happening only on one machine ? / Multile machines are having the same issue ?
ReplyDeleteCould 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..
I came across this website and saw that you had a similar issue.
ReplyDeleteSo, 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
-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
ReplyDeleteIf 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...
Hello mol Ghuge,
ReplyDeleteI 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
lets do these steps:
ReplyDeleteThe 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...
Hello Amol,
ReplyDeleteThanks 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
it is surely a machine specific issue and not from the SharePoint side.
ReplyDeleteCan 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.
Thanks so much!
ReplyDeleteThe 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
Hi Amol,
ReplyDeleteOne 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?
Hello Kumar,
ReplyDeleteIf 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..
Hi Amol,
ReplyDeleteThank 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?
Hello Kumar,
ReplyDeleteIf 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..
Thank you for the quick response, will get back to you soon on the above recommendations.
ReplyDeleteAnother solution that I found , in IE disable the sharepoint add-ons and enable them back and restart the browser. Worked like a charm .
ReplyDeleteMost of the solutions did not work for me.
Thank you for the valuable feedback by means of alternate solution! This will be definitely useful for all the SharePoint communities!!!
Deletethanks 4 sharing the information, this will be definately useful to the sharepoint users across the whole world, Thanks again :-) :-)
ReplyDeletenice blogs and very informative content .....
ReplyDeleteDocument Editing Services
Thank you Rohit!
DeleteHi Amol,
ReplyDeleteThank 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
Hi Amol,
ReplyDeleteNeed 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
are you getting any error message?
Deletewhat 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.....
If yοu want to get a great deal from
ReplyDeletethis ρost thеn you haѵe to apply suсh methods to your ωon web sіte.
my weblog: supplement
Hi Amol,
ReplyDeleteI 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.
make sure that the office application should be installed on the machine where he is facing the problem.
DeleteThis 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.
Thank you for this valuable info!
ReplyDeleteMy pleasure :)
DeleteIt is not my first time to pay a quick visit this web site, i am browsing this web
ReplyDeletepage dailly and obtain nice data from here every day.
Also visit my blog post; online business management school
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.
ReplyDeleteLipstick 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
Way cool! Some extremely valid points! I appreciate
ReplyDeleteyou penning this article and the rest of the site is also really
good.
Have a look at my web blog - Axl Hazarika
Thank you!
DeleteSimply wish to say your article is as astonishing.
ReplyDeleteThe 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
Il me tаrdе de liгe &X6C;e prochain poste
ReplyDeleteAlso vi&X73;іt my webs&X69;te; Gourmande Femme Mature
Est-i&X6C;pοѕsible de vo&X75;s pi&X71;uer
ReplyDeletecertaines 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)
It's a shame you don't have a donate button! I'd certainly donate to
ReplyDeletethis 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
Det er en premisser for innhold og teste gratis spilleautomater denne nettutgaven
ReplyDeletevirkelig 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
It can be really difficult finding a decent SEO business
ReplyDeletenowadays, just going to do it myself I think
Emile le téléphone la moyenne son centre toit.
ReplyDeleteDans 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
Definitely believe that which you said. Your favorite justification seemed to be
ReplyDeleteon 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 ()
Hi Amol,
ReplyDeleteAt 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!!
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