Overview
Essentially, the Excel Service allows Excel workbooks to be published and connected across the SharePoint environment. It is commonly classified as a “business intelligence” tool as it allows connection (and automatic refreshing of) external data sources, creation of reports, publishing to a document library and then rendering in the browser.
Prerequisites
- SharePoint 2013 Enterprise Edition