Re: How to refresh dropdown lists in PivotTables?

[Eleanor M]

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

[Debra Dalgleish]

Perhaps you included a blank column when you created the database range.

Eleanor M wrote:
> 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


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

[Eleanor M]

Thanks it was the header of the columns wadn't included. BTW how do you sort
without rearranging the header in the sort? It gets sorted with all the data
and that confuses the pivot table refresh.
--
Estandardtime Realty


"Debra Dalgleish" wrote:

> Perhaps you included a blank column when you created the database range.
>
> Eleanor M wrote:
> > 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
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

[Debra Dalgleish]

If you format the heading row differently than the rest of the table,
e.g. Bold font, it should automatically be detected. Then it will remain
at the top after the sort.

Or, choose Data>Sort, and specify that a header row is included.

Eleanor M wrote:
> Thanks it was the header of the columns wadn't included. BTW how do you sort
> without rearranging the header in the sort? It gets sorted with all the data
> and that confuses the pivot table refresh.


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

[Eleanor M]

Thanks I will try that. BTW what webpage editing software do you use. Your
pages are clearly illustrated.

Best Regards,
EMoorhead
--
Estandardtime Realty


"Debra Dalgleish" wrote:

> If you format the heading row differently than the rest of the table,
> e.g. Bold font, it should automatically be detected. Then it will remain
> at the top after the sort.
>
> Or, choose Data>Sort, and specify that a header row is included.
>
> Eleanor M wrote:
> > Thanks it was the header of the columns wadn't included. BTW how do you sort
> > without rearranging the header in the sort? It gets sorted with all the data
> > and that confuses the pivot table refresh.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

[Debra Dalgleish]

I use Dreamweaver, and SnagIt for the screenshots.

Eleanor M wrote:
> Thanks I will try that. BTW what webpage editing software do you use. Your
> pages are clearly illustrated.
>
> Best Regards,
> EMoorhead


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

[Eleanor M]

The bold font was already done and it still sorted. Confusing issue.

Best Regards,
EMoorhead
http://www.estandardtime.com

--
Estandardtime Realty


"Debra Dalgleish" wrote:

> If you format the heading row differently than the rest of the table,
> e.g. Bold font, it should automatically be detected. Then it will remain
> at the top after the sort.
>
> Or, choose Data>Sort, and specify that a header row is included.
>
> Eleanor M wrote:
> > Thanks it was the header of the columns wadn't included. BTW how do you sort
> > without rearranging the header in the sort? It gets sorted with all the data
> > and that confuses the pivot table refresh.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>