During a recent project I was involved in I had to stop using ODC Connection files embedded in my Excel files when using Excel Services and SharePoint 2010.
The reason was that whenever a user clicked Open in Excel depicted below
The excel client would not open the report but rather open the ODC file itself which is of course is incorrect behavior. This issue was rectified in a hotfix released by Microsoft recently.
http://support.microsoft.com/kb/2596582
The reason was that whenever a user clicked Open in Excel depicted below
The excel client would not open the report but rather open the ODC file itself which is of course is incorrect behavior. This issue was rectified in a hotfix released by Microsoft recently.
http://support.microsoft.com/kb/2596582
