Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown Lists | Excel Discussion (Misc queries) | |||
Dropdown Lists... | Excel Discussion (Misc queries) | |||
continuing dropdown lists | Excel Worksheet Functions | |||
Dropdown lists | Excel Discussion (Misc queries) | |||
how do I add data validation dropdown lists to a Form | Excel Worksheet Functions |