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

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