CHAPTER 8

Pivot Table Security, Limits, and Performance

If other people have access to your pivot table, you may want to disable some of the features, address privacy concerns, monitor access to protected data sources, or prevent users from making some changes. Some pivot table security settings require programming, and are discussed in Chapter 11. Other settings can be made manually, and are explained here.

When a pivot table is based on external data, Excel's security settings can affect your ability to update the pivot table. You can change the security settings, to control the security warnings displayed when you connect to the file. The external data source may have a password you'd like to store in your Excel file, to make it easier to connect.