CHAPTER 11Programming a Pivot Table

Although you can create complex pivot tables without programming, some pivot table settings can only be changed by using programming. As a developer, you can use programming to limit the ways users can manipulate your pivot tables, or to simplify a complex set of tasks. For example, you can provide a button on the worksheet that users can click to format, refresh, and preview a pivot table before printing.

This chapter addresses programming issues related to pivot tables and provides code examples for macros that can't be recorded. The chapter begins with a brief introduction to using Excel's macro recorder and the Visual Basic Editor (VBE), where you can view and edit the code stored in the workbook's modules. ...

Get Excel 2007 PivotTables Recipes: 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.