CHAPTER 10Publishing a Pivot Table

After you create a PivotTable report, you may want to publish the pivot table, its pivot chart, or the entire workbook, on a web page. In Excel, you can create files in HTML format, with or without interactivity. Without interactivity, a PivotTable or PivotChart report can be viewed on a web page, but not manipulated. With interactivity, visitors to the web page can modify the PivotTable or PivotChart report layout, select from the pivot field dropdown lists, and make other changes.

If you choose to add interactivity, an Office Web Component (OWC) is created, based on the Excel worksheet, pivot table, or pivot chart. In order to view or interact with your OWC PivotTable list, visitors to the web page need to ...

Get Excel Pivot Tables Recipe Book: A Problem-Solution Approach now with O’Reilly online learning.

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