October 2010
Intermediate to advanced
1008 pages
46h 16m
English
Integration between Excel spreadsheets and SharePoint has been a hot topic for years, and Microsoft has provided a number of methods to integrate the two products. This section reviews some different basic methods of working with Excel data in SharePoint to prepare for additional discussions around Excel Services.
To begin with, a SharePoint list has many similarities with an Excel spreadsheet, so many organizations simply move the content from the spreadsheet to SharePoint by creating a list; replicating the column headings, order, and type of content; and then cutting and pasting from the worksheet into the SharePoint list. This is a fairly painstaking process, so many users instead use the Import ...
Read now
Unlock full access