8. Sharing Pivot Tables with Others

In This Chapter

Designing a Workbook as an Interactive Web Page

Sharing Pivot Tables with Other Versions of Office

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 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.

Start your free trial