K
kiln
I need my pivot table to have two modes - one that is free-form where
the user can configure the pivot table in the typical manner, and a
second where changes are almost locked out. In this second "locked"
mode, I would like to only allow certain axis changes and nothing else.
Specifically, I'd allow swapping of fields between row/col/filter, and
prevent any change to the detail axis. I've found little of use on this
newsgroup or the help file that deals with this issue. Suggestions?
the user can configure the pivot table in the typical manner, and a
second where changes are almost locked out. In this second "locked"
mode, I would like to only allow certain axis changes and nothing else.
Specifically, I'd allow swapping of fields between row/col/filter, and
prevent any change to the detail axis. I've found little of use on this
newsgroup or the help file that deals with this issue. Suggestions?