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

Always keep the same 4 PivotItems visible
 

You could adapt the technique in the sample workbook he

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

Always keep the same 4 PivotItems visible
 

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

Martin


"Debra Dalgleish" wrote:

You could adapt the technique in the sample workbook he

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