How to refresh dropdown lists in PivotTables?
 

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

How to refresh dropdown lists in PivotTables?
 

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

How to refresh dropdown lists in PivotTables?
 

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

How to refresh dropdown lists in PivotTables?
 

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

How to refresh dropdown lists in PivotTables?
 

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

How to refresh dropdown lists in PivotTables?
 

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

How to refresh dropdown lists in PivotTables?
 

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