Connection from Excel to PowerPivot File in Sharepoint


  • Hello,

    I've uploaded a PowerPivot file to Sharepoint: PowerPivotDB.xlsx

    Now I want to build in a SEPARATE Excel file a dashboard that is connected to that PowerPivot file in Sharepoint

    I want my users to be able to analyze the dashboard both in Excel services (through web explorer) and in Excel itself (after clicking "Open in Excel" button in Sharepoint)

    When they try to open the DASHBOARD file in sharepoint they get ERROR message:

    Unable to refresh data for a data connection in the workbook.
    Try again or contact your system administrator. The following connections failed to refresh:

    Please Help


    Michael Shparber


    Thursday, March 21, 2013 3:21 PM


All replies