Lesson plan

Excel Services

Excel Services is a server technology included in SharePoint 2010 and SharePoint 2007. This shared service enables users to load, calculate, and display Excel 2010 workbooks on Microsoft Office SharePoint Server 2010. Using Excel Services, users can reuse and share Excel workbooks on Microsoft Office SharePoint Server 2010 portals and dashboards. For example, they can create content in Excel 2010 and share it by using an Office SharePoint Server 2007 portal and dashboard. The entire workbook or just parts of it (such as just a single sheet, chart or table) can be shared. End-users can view live, interactive workbooks using only a web browser. They can also interact with workbooks to explore data, and analyze Pivot Table reports and charts by using a browser. Excel Services supports workbooks that are connected to external data sources. Users can embed connection strings to external data sources in the workbook or save them centrally in a data connection library file. Selected cells in worksheets can be made editable by making them named ranges or "parameters". Items which are set as "viewable", when they save to Excel Services, will appear in the Parameters pane in the browser. Users can change the values of these named ranges in the parameters pane and refresh the workbook.…

Back to article

Article summary

Excel Services is a server technology included in SharePoint 2010 and SharePoint 2007. This shared service enables users to load, calculate, and display Excel 2010 workbooks on Microsoft Office SharePoint Server 2010. Using Excel Services, users can reuse and share Excel workbooks on Microsoft Office SharePoint Server 2010 portals and dashboards. For example, they can create content in Excel 2010 and share it by using an Office SharePoint Server 2007 portal and dashboard. The entire workbook or just parts of it (such as just a single sheet, chart or table) can be shared. End-users can view live, interactive workbooks using only a web browser. They can also interact with workbooks to explore data, and analyze Pivot Table reports and charts by using a browser. Excel Services supports workbooks that are connected to external data sources. Users can embed connection strings to external data sources in the workbook or save them centrally in a data connection library file. Selected cells in worksheets can be made editable by making them named ranges or "parameters". Items which are set as "viewable", when they save to Excel Services, will appear in the Parameters pane in the browser. Users can change the values of these named ranges in the parameters pane and refresh the workbook.…

Key claims

No claims recorded.

Discussion questions

  1. Summarise the article in your own words. Which single claim would you verify first, and why?
  2. Which claim in this article is most likely to be revised as the sources update? How would you check its current status?
  3. If two sources disagreed about one of these facts, what would you need in order to trust one over the other?

Bibliography

No sources recorded.

Key claims and bibliography are generated from the same tracked claims and sources as the article page.