Publishing Excel with Excel Services

Abstract

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. Not to say that these capabilities do not add value, but for a tool as popular as Excel has become, you may expect more.