If you want to give them full control of the pivot table except for one
field, I don't believe there is any support for that. Why couldn't the user
just remove it as a page field? You could always reset it with a macro, but
the user could disable macros. I don't see a quick and easy solution, but
someone else may have some ideas.

--
Regards,
Tom Ogilvy




"Timothy via OfficeKB.com" wrote:

Tom,

That was my first thought, but if you add or remove any page fields, then the
hidden field comes into view and the subsequent field moves to the hidden row.
These reports are manipulated extensively by many different users, many of
which have very basic computer skills. I just need to make sure that this
one field stays in the page field section at all times and cannot be changed.

Tom Ogilvy wrote:
Perhaps hide the row that contains the pagefield you want locked.

I have a page field in a pivot that I need one value selected in. This
selection is critical to the legitimacy of the pivot table data. I need to
[quoted text clipped - 13 lines]

Tim

--
Message posted via http://www.officekb.com