Excel 2003 pivot table 1

[Brian555]

I am struggling with an issue in a pivot table

I have a pivot table in which i wish to permantly restrict the row selection to a set of specific items, i.e exclude any new fields when refreshing the pivot table. Is this possible?

Any help would be greatly appreciated

 

[SkipVought]

hi,

What about protecting the sheet appropriately?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Brian555]

Skip

The simplest solutions are often the best.

Many thanks for your help