O'Reilly logo

Excel Pivot Tables Recipe Book: A Problem-Solution Approach by Debra Dalgleish

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required