8. Sharing Pivot Tables with Others

Say that you’ve built an awesome pivot table with slicers. You would like people to be able to interact with the pivot table but you don’t want them to be able to rearrange the pivot table, nor do you want them to be able to access the underlying data. This is now possible via several avenues:

• The Excel Web App and SkyDrive can let you turn your Excel workbook into an interactive web app with ease. A SkyDrive account is free, and this method will accommodate files up to 10MB in size.

• If your company has a SharePoint Enterprise Server plus SQL Server BI Edition, you can publish an interactive ...

Get Excel 2013 Pivot Table Data Crunching now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.