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

1 Answer 1


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:

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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