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:

ActiveSheet.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

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:

ActiveSheet.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

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:

ActiveSheet.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

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:

ActiveSheet.PivotTables("ReportPivot").PivotCac he.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