I exported an odc file from excel to a sharepoint data connections web part (Always attempt to use this file to refresh data as checked in the Data Connection Wizard). I then navigated to the sharepoint site and clicled on the .odc file listed. After enabling the data connection in Excel i got the following message:

Excel was unable to get necessary information about this cube. The cube might have been reorganizard or changed on the server. Contact the OLAP cube administrator and if necessary set up a new data source to connect to the cube.

Now ,i know the cube is not the problem because after exporting the connection i saved the workbook locally ,which i can use to connect to the cube and create pivot tables with no issues; only when i click on the odc listed on the sharepoint site i get the error in excel.

Any ideas?