| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot table and Dsum security
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot table and Dsum security
It's not foolproof, but you can use worksheet protection, or programming
to lock parts of the pivot table. There's sample code he http://www.contextures.com/xlPivot12.html A cell with a DSUM formula can be locked, and the sheet protected. Heather wrote: 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 Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compare data in two pivot tables | Excel Discussion (Misc queries) | |||
| Create A List From A List | Excel Worksheet Functions | |||
| Disjoint range for DSUM criteria | Excel Worksheet Functions | |||
| using DSUM in formulae instead of SUMIF | Excel Worksheet Functions | |||
| Add a formula to Pivot Table | Excel Worksheet Functions | |||
Linear Mode
