You're welcome. I'm not sure what you mean about the annual totals, but
uou can prevent the GetPivotData formulas from appearing. There are
instructions here for adding the Generate GetPivotData button to a
toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html


Gordon Humphreys wrote:
Thank you Debra Not the worst disappointment with Excel XP/2000 [The whole
Pivot table stuff now seems to have been 'improved worse' in a big way eg
annual total including bits from preceding and following years, and
'getpivotdata' instead of a regular cel ref .....]

"Debra Dalgleish" wrote:


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





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