Use the CData ODBC Driver for Salesforce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce to connect to Salesforce & Force.com from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce & Force.com in Excel.