Publishing Excel with Excel Services
You saw in the last chapter that, by itself, Excel does not bring as much capability to the table of collaboration as Word, Outlook, and Access. With the decision 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, perhaps you expect more.
KeywordsCell Range Data Connection Excel Service Excel Worksheet Pivot Table
Unable to display preview. Download preview PDF.