Controlling/Preventing Axis Changes in Pivot Table

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top