up vote 1 down vote favorite
1
share [g+] share [fb]

While trying to open an excel document stored in "Shared Documents" library, the excel application opens up with a login prompt, to which I passed the login credentials of the site. After which the excel shows an error 

"Could not open 'http://sp2010//shared documents/Sales.xlsx'"

The same is the case for word documents too. I am running SharePoint 2010 server on windows 2008 R2. The same machine is used for development. MS Office 2010 Professional plus installed on the same machine (not activated). The browser version i am using is IE8.

After searching the net, I tried the following steps but nothing turned to solve the problem

  1. Enabled the "Desktop Experience" feature in windows server 2008

  2. Unchecked "Auto proxy detection" in IE settings.

  3. Added the site to trusted list in IE.

  4. In excel added the Sharepoint the URL 'http://sp2010/' under 'Trust Center' options.

  5. In excel unchecked all "protected view" options under 'Trust Center'.

  6. Tried applying the "127.0.0.1" as proxy, didn't work and reverted it back.

I tried opening the 'Sales.xlsx' after downloading the file from "Shared Documents", which opened up without any issues.

Now I am completely out of options on what to do next to get this working.

Please help.

Update: I had disabled the server firewall but the problem still persisted. Thereafter I mapped a network drive to the following url 'http://sp2010' to which I was able to browse the location where the 'Sales.xlsx' was located. But opening file from this location too gave me the same error.

Update: Finally it seems like I had got the culprit behind this wired behavior. I am posting the steps that worked for me. It seems the temp contents in the 'OfficeFileCache' along with SharePoint workspace was the reason behind the issue.

link|improve this question
64% accept rate
feedback

3 Answers

up vote 1 down vote

The only thing I can think of is that when opening a file from SharePoint directly, Word uses WebDAV to communicate with the server. If this protocol is disabled in the firewall for instance, Word would be unable to retrieve the contents of the file.

link|improve this answer
Yeah as you said I did disable the firewall too, but still the same. I was able to sucessfully map the url to my site sp2010 as a network drive under "My Computer" and was able to browse the same, but if I try to open documents from there, then again the same problem shows up. Anyway thanks for pointing out any chances with firewall. – AbrahamJP Jun 24 '11 at 17:55
Another thing: In the web app's general settings (Central admin -> web apps, select web app, general settings in the ribbon), do you have client integration enabled? – Colin Jun 24 '11 at 17:59
I did verify the option you had mentioned. The 'Client Integration' is enabled for the web app. thanks for that. I believe, I am almost near to the solution after clearing the 'OfficeFileCache'. – AbrahamJP Jun 24 '11 at 18:25
feedback
up vote 1 down vote accepted

I noticed that SharePoint Worksapce was running in the system tray which had the "Shared Documents" library synced, because of this there were some temp files out there in the following location

"c:\Users\login_user_name\AppData\Local\Microsoft\Office\14.0\OfficeFileCache"

after terminating the Sharepoint workspace and clearing those temp files, I was able to open documents in Office client.

link|improve this answer
feedback
up vote 0 down vote

Also make sure that Word has access to the network. I sumbled across this in a VM with no network support : in this case, even in local, word won't open the document after all this.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.