Office and Share Point 2010 User's Guide: Integrating SharePoint with Excel, Outlook, Access and Word

Chapter 8. Publishing Excel with Excel Services

You saw in Chapter 7 that Microsoft Office Excel does not, by itself, bring as much capability to the table of collaboration as Word, Outlook, or Access. Because Microsoft has decided to deprecate synchronization between Excel and SharePoint lists, your initial impression may be that the only value Excel can offer might lie in its ability to help you create lists from other data sources. Perhaps if you can export other data into an Excel format or maybe read it into Excel, you might subsequently export it to a new SharePoint list. Similarly, you might transfer the data from a SharePoint list to an Excel worksheet so that you can save it perhaps as a CSV file that other applications might then import. ...