Pivot table and Dsum security

[Guest]

Can someone tell if it is possible to secure a pivot table? (Aside from
locking down the cells.) If you also know how to secure the Dsum fuction
please let me know.

Thank you,

Heather

 

[Debra Dalgleish]

It's not foolproof, but you can use worksheet protection, or programming
to lock parts of the pivot table. There's sample code here:

http://www.contextures.com/xlPivot12.html

A cell with a DSUM formula can be locked, and the sheet protected.