Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controlling Pivotitems.visible | Excel Discussion (Misc queries) | |||
Pivot Change PivotItems - Visible/Hide with VBA | Excel Worksheet Functions | |||
PivotItems.Count is 0 when items are visible on the sheet | Excel Programming | |||
Excel Pivot Tables, Page Fields, Visible PivotItems, Activation | Excel Programming | |||
Add PivotItems to PivotTable / Enabling - Disabling PivotItems | Excel Programming |