CHAPTER 13Programming 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 that 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 will address programming issues related to pivot tables and provide 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 code is stored. Many excellent books are available with ...

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

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