Publishing a PivotTable on the Web

When you publish an Excel workbook on the Web, you can allow users to interact with the worksheets. The preceding section of this chapter described how to let you and your colleagues interact with an Excel document over the Web. This section continues that theme by demonstrating how to export a PivotTable to the Web. If Catherine Turner, The Garden Company’s owner, were on vacation but wanted to participate in a meeting, she could still use her laptop to connect to the company’s Web site and use a PivotTable published there to view any updated information.

Once you have created a PivotTable, you can publish it on the Web by clicking any cell in the PivotTable and clicking Save as Web Page on the File menu to open ...

Get Microsoft® Office Excel® 2003 Step by Step 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.