8. Sharing Pivot Tables with Others
As pivot tables evolved in Excel 2007 and Excel 2010, certain incompatibilities were introduced when you share your pivot table with people using legacy versions of Office.
Office 2003 had offered a way to share pivot tables with interactivity to a web page using Office Web Services. This ability was removed in Excel 2007 and is now replaced in Excel 2010 using the Excel Web Application. The Excel Web Application offers interactivity with slicers. The Excel Web Application is actually a hosted version of the Excel Services functionality introduced in Excel 2007 for people using SharePoint.
Sharing ...
Get Pivot Table Data Crunching: Microsoft® Excel® 2010 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.