Re: Refreshing Pivot table Pull Downs

Tech-Archive recommends: Speed Up your PC by fixing your registry

You're welcome. Thanks for letting me know that it worked for your MS SQL database.

MChrist wrote: 
Thanks Debra,

That works so sweetly.

Have a great day.

Mark

"Debra Dalgleish" wrote:


There are instructions here for clearing old items from the dropdown lists:

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

MChrist wrote:

I have a pivot table that lists various items by period. I'm importing data for a pivot table from an MS SQL database. And after the import I'm using:

Active***.PivotTables("ReportPivot").PivotCache.Refresh

to refresh the pivot table after the data is updated.

The problem I am having is the Pull Down for selecting which periods to include in the pivot is not updating with the updates. While it includes new periods are added, the previous periods that are no longer in the dataset are also included (the report periods in the data are 2004-2005, but the pull down includes periods from 2003-2005).

Is there a way either through VB code or an option I'm missing to force the pull downs to refresh?

Thanks for your help.

Mark 


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





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

.

Quantcast