CHAPTER 8Pivot 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 ...
Get Excel 2007 PivotTables Recipes: A Problem-Solution Approach 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.
