Hi,

I am working on an application that needs to retrieve data from a sharepoint site using Excel Services. I have installed Sharepoint Server 2010 on my own machine and my code works just fine for it.

However, when I run it for a workbook stored on the company's sharepoint site, I get a Soap Exception which says "The file that you selected could not be found. Check the spelling of the file name and verify that the location is correct."

Now I can view this workbook if I go to the link that I am using, which is of the form http://<server>/<sub-site>/<doc-lib>/workbook.xlsx through my browser. I think the problem is somewhere with authentication. I cannot use DefaultCredentials for my application. So how should I specify credentials with the Excel Services object?