Always keep the same 4 PivotItems visible

Hi All,

Problem in Excel 2000.

I have a PivotTable where I always want to keep the same 4 PivotItems
visible.

The problem I am facing is that the source of the data is frequently updated
with new data. Accordingly PivotItems might be added or removed following an
update.

I have tried to apply suggestions in the thread - but that coding is leaving
the last PivotItem in the list. The last PivotItem could be the one of the 4
I want to display but what do I do when there are more PivotItems below?

Really appreciate help to solve my problem.

--
Regards,

Martin

You could adapt the technique in the sample workbook here:

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

Under PivotTables, look for 'Pivot 97/2000 Show Marked Items'

Martin wrote:
> Hi All,
>
> Problem in Excel 2000.
>
> I have a PivotTable where I always want to keep the same 4 PivotItems
> visible.
>
> The problem I am facing is that the source of the data is frequently updated
> with new data. Accordingly PivotItems might be added or removed following an
> update.
>
> I have tried to apply suggestions in the thread - but that coding is leaving
> the last PivotItem in the list. The last PivotItem could be the one of the 4
> I want to display but what do I do when there are more PivotItems below?
>
> Really appreciate help to solve my problem.
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Debra, thanks a lot. It is working like a dream.
--
Regards,

Martin


"Debra Dalgleish" wrote:

> You could adapt the technique in the sample workbook here:
>
> http://www.contextures.com/excelfiles.html
>
> Under PivotTables, look for 'Pivot 97/2000 Show Marked Items'
>
> Martin wrote:
> > Hi All,
> >
> > Problem in Excel 2000.
> >
> > I have a PivotTable where I always want to keep the same 4 PivotItems
> > visible.
> >
> > The problem I am facing is that the source of the data is frequently updated
> > with new data. Accordingly PivotItems might be added or removed following an
> > update.
> >
> > I have tried to apply suggestions in the thread - but that coding is leaving
> > the last PivotItem in the list. The last PivotItem could be the one of the 4
> > I want to display but what do I do when there are more PivotItems below?
> >
> > Really appreciate help to solve my problem.
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>