Allowing "use pivot table reports" means that users can change make some
changes to an existing pivot table, such as moving fields, showing and
hiding items, and sorting.

To use other features, such as refreshing the pivot table, the sheet
must be unprotected.

Gordon Humphreys wrote:

Debra Dalgleish, if I understand correctly, suggests recording a small macro
to allow refreshing a protected pivot table.

But what is the point of the 'Tools, protect sheet, Use pivot table
reports' ? It seem to allow nothing.

How is it supposed to work or is my Excel faulty?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html