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
Enabled the "Desktop Experience" feature in windows server 2008
Unchecked "Auto proxy detection" in IE settings.
Added the site to trusted list in IE.
In excel added the Sharepoint the URL 'http://sp2010/' under 'Trust Center' options.
In excel unchecked all "protected view" options under 'Trust Center'.
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.
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.