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

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