Ok, I have looked but can't find the answer I am looking for.

Background: There was a pivot table created which is linked to either a
sheet in the same workbook or I have also linked it to an external datasource
which has the same dataset layout and fields.

I have the need to create multiple sets of this pivot table and change the
actual dataset that it uses. I don't have any problems with this or with
refreshing the data.

The issue I am having is in the Pivot Table Field drop downs. Once there
data is refreshed the old values from the other data set are still present in
the dropdown and are actually hidden.

How do I get rid of these field values as a selection in the drop down for
the filtering?

Did I give enough information or do you need further clarification.

Thanks
Robert

See these websites:

http://www.contextures.com/xlPivot04.html
http://www.contextures.com/xlPivotPlay01.html#ProcOpts

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Robert" wrote:

Ok, I have looked but can't find the answer I am looking for.

Background: There was a pivot table created which is linked to either a
sheet in the same workbook or I have also linked it to an external datasource
which has the same dataset layout and fields.

I have the need to create multiple sets of this pivot table and change the
actual dataset that it uses. I don't have any problems with this or with
refreshing the data.

The issue I am having is in the Pivot Table Field drop downs. Once there
data is refreshed the old values from the other data set are still present in
the dropdown and are actually hidden.

How do I get rid of these field values as a selection in the drop down for
the filtering?

Did I give enough information or do you need further clarification.

Thanks
Robert

The manual process didn't work, I had tried that already however, creating
the subroutine and doing it programatically worked like a charm.

THANK YOU!

Robert

"Ron Coderre" wrote:

See these websites:

http://www.contextures.com/xlPivot04.html
http://www.contextures.com/xlPivotPlay01.html#ProcOpts

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Robert" wrote:

Ok, I have looked but can't find the answer I am looking for.

Background: There was a pivot table created which is linked to either a
sheet in the same workbook or I have also linked it to an external datasource
which has the same dataset layout and fields.

I have the need to create multiple sets of this pivot table and change the
actual dataset that it uses. I don't have any problems with this or with
refreshing the data.

The issue I am having is in the Pivot Table Field drop downs. Once there
data is refreshed the old values from the other data set are still present in
the dropdown and are actually hidden.

How do I get rid of these field values as a selection in the drop down for
the filtering?

Did I give enough information or do you need further clarification.

Thanks
Robert