Export (0) Print
Expand All
2 out of 4 rated this helpful - Rate this topic

Share data connections by using Excel and Excel Services (SharePoint Server 2013)

SharePoint 2013

Updated: February 5, 2013

Summary: Excel Services enables you to work with different external data sources to create reports, scorecards, and dashboards that remain up to date automatically.

Applies to:  SharePoint Server 2013 Enterprise 

Excel can connect to lots of different data sources. These include SQL Server, a SharePoint list, an Access database, a Windows Azure DataMarket Feed, an OData feed, and so on. Many of the data connections that you can use in Excel are supported as data connections in Excel Services. This means that people can refresh data in Excel Services reports, scorecards, and dashboards that use those data connections. More specifically, Excel Services supports connections to SQL Server tables, SQL Server Analysis Services cubes, and custom OLE DB/ODBC data providers.

By storing data connections in an Excel Services trusted data connection library, people can easily access the data sources that they need without having to know the names of servers and databases. Data connections are reusable so that people can create multiple reports or workbooks using those data connections. In addition, Excel Services workbooks that use connections in a trusted data connection library can be updated so that people have easy access to current information.

Use the articles in this section to learn how to create and publish external data connections using Excel Services.

In this section

Change History

Date Description

February 05, 2013

Added a link to a new article in this section.

October 16, 2012

Initial publication

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.