Excel Pivot Tables Recipe Book: A Problem-Solution Approach

CHAPTER 8Securing a Pivot Table

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 13. Other settings can be made manually, and are explained here.

In Excel, you can protect a file with a password when saving it. You can also password protect a workbook's structure and windows, as well as its worksheet contents. The Microsoft Office 2003 Editions Security Whitepaper (www.microsoft.com/technet/prodtechnol/office/office2003/operate/o3secdet.mspx) discusses security threats that exist and security technologies ...