Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivotitems updating pivottable.... help!!!
I have a workbook containing some specific clients on sheet (1) and
a pivot Table on another sheet I need to update the Pivot Table with only those Clients when I refresh the Pivot Table(“SpecClient”). Example :- Range Name (Sheet(1)!$K$3:$K$28 ) Client 104 Client 054 Client 730 Client 062 I would like to see in Pivot Table.pivot Items only clients 104, 054, 730, 062 and eventually another one should I add another client in the existing Range. The Clients on the pivot table are on a page field. heres an example.. With ActiveSheet.PivotTables("SpecClient").PivotFields( "Name") For CliName = 1 To Range Name If cell is not empty then .PivotItems(CliName).Visible = False End If Next CliName End With This works exactly the way i want but for one thing. The pivot table is being updated as soon as change one of the pivotitems visible property. This is annoying and slow. I will like to make all my changes first then have the pivot table refreshed. I added these 2 lines to my code... Application.EnableEvents = False Application.ScreenUpdating = False but its still terribly slow.... to see what im talking about... create a pivot table... add a pagefield.. record a new macro....select multiple items of the page field... and stop the macro... now run the new macro... see how many times the table is refreshed?... can anyone help? -- --------------------------------- --- -- - Posted with NewsLeecher v3.9 Beta 8 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating PivotTable SourceDate using VBA | Excel Programming | |||
PivotItems Bug?! | Excel Programming | |||
Addin for updating database by ammending pivottable | Excel Discussion (Misc queries) | |||
Adding PivotItems | Excel Programming | |||
Add PivotItems to PivotTable / Enabling - Disabling PivotItems | Excel Programming |