I'm getting this error message when trying to refresh a workbook.
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?
If I manually uncheck the "Always use connection" setting as follows:
Then I still get an error: