I have a similar problem with my pivot table.
Whenever I click on refresh data an error message displays that PivotTable
field name is not valid. I followed your website contexture on defining the
database word for word and it worked but now I try to refresh the data I get
the error message.
Please advise.
Best Regards,
EMoorhead
--
Estandardtime Realty
"Debra Dalgleish" wrote:
> There are instructions here for clearing old items from a PivotTable
> dropdown list:
>
> http://www.contextures.com/xlPivot04.html
>
>
> Seraphim wrote:
> > The dropdown lists in our PivotTables are not refreshing -- they still show
> > items that no longer exist in the original data.
> >
> > How do I refresh the Pivot Table so these items disappear? Just clicking on
> > Refresh doesn't clear the dropdown lists.
> >
> > Thanks.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>
Bookmarks