I'm getting this error message when trying to refresh a workbook.

The odc file is saved in the Data Connections library of the sub-site. The excel olap pivot report is saved in a document library of the same sub-site.

Which setting will I need to change?

enter image description here

If I manually uncheck the "Always use connection" setting as follows:

enter image description here

Then I still get an error:

enter image description here


To work around this issue, follow these steps:

  1. Open the workbook in an Excel client application.
  2. Select the data connection that is listed in the error message, and then click Properties under the Data tab.
  3. Clear the Always use connection file check box under the Definition tab.
  4. Republish the workbook to the WAC server.

here is the KB for above: 2758432

also check this Technet for configuring it:

| improve this answer | |
  • +1 thanks for this information but when i do this I still get an error message: I will edit OP. – whytheq Mar 13 '14 at 8:15
  • 2758432 is not correct in this context: SharePoint Server should support odc files that link through to Analysis Services cube. – whytheq Mar 13 '14 at 9:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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