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 a couple avenues:

Image Excel Online and OneDrive let you turn your Excel workbook into an interactive web app with ease. A OneDrive account is free, and this method will accommodate files up to 10MB in size.

As of July ...

Get Excel® 2016 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.