Creating an Excel spreadsheet to run on the server

In this recipe you will see how to upload your spreadsheet to the server and use the Excel Web Part to expose its information within your SharePoint pages.

Getting ready

This recipe works for:

  • SharePoint 2010 Enterprise Edition
  • SharePoint 2010 Online (Office 365 Edition)

You will need an Excel spreadsheet (containing your data) and a SharePoint site with a document library where you wish to upload your spreadsheet. Excel services will need to be enabled on the server and the document library set as a trusted location (check with your SharePoint administrator if you are unsure about this).

To publish and upload the spreadsheet you will need Microsoft Excel 2010 and the Contribute permissions level.

Get Microsoft SharePoint 2010 Power User Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.