Buzz
The following article provides a detailed introduction to the basic concepts of Excel Services in Excel 2013.
1. What is Excel Services?
- Excel Services is a SharePoint technology that extends Excel using server technology. It allows users to access a workspace from a browser even when your computer does not have Excel.
- Excel Services comprises 3 constituent parts:
+ Excel Calculation Services: This is the main component of Microsoft SharePoint Server. It performs loading of workbooks, calculation of precision, data updates, and session maintenance. The services perform computations in the cloud, hence users cannot access functions and formulas directly.
+ Excel Web Access: It is a web component that helps display the entire or a portion of a workbook allowing users to interact with the workbook in the browser.
+ Excel Web Services: Provides an application programming interface.
- Since Excel utilizes SharePoint technology, users can leverage security features and management on their devices.
- In scenarios where users wish to access functions and formulas integrated into Excel but not available in Excel Services, they can utilize the Open Snapshot feature of Excel Services: click on Open -> Snapshot in Excel:
2. Can Excel Service and Excel work together?
- Excel is considered the author and Excel Service is considered the reporting tool, so Excel and Excel Service can collaborate.
3. Saving a workbook to SharePoint.
- After creating a dataset in Excel 2013, if you want to aggregate additional data sources from other departments without altering the source data, upload them to SharePoint, grant access permissions to the necessary accounts. With just a simple step like this, you have compiled a quick, comprehensive, and accurate report.
Above is a basic introduction to Excel Services in Excel 2013.
Wishing you success!
