Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Data did not update
I copied and pasted data into a current Pivot Table data Sheet. I reviewed
the wizard to be sure that my rows and column lengths were correct. I refreshed the data, but the dropdowns for the Pivot Tables columns contain old and new information. When I refresh data, should the column dropdowns update? What am I missing? Thanks Dave K |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Data did not update
Dave, not sure how you are copying and pasting data into pivot table.
If your souce data is dynamic, i.e you add data all the time and want pivot table to consider it, follow the procedure outlined at this link http://www.contextures.com/xlPivot01.html Let me know if it works. Nagesh "Dave" wrote: I copied and pasted data into a current Pivot Table data Sheet. I reviewed the wizard to be sure that my rows and column lengths were correct. I refreshed the data, but the dropdowns for the Pivot Tables columns contain old and new information. When I refresh data, should the column dropdowns update? What am I missing? Thanks Dave K |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Drill down to source and update | Excel Discussion (Misc queries) | |||
Pivot Table update | Excel Discussion (Misc queries) | |||
How do I set the pivot table to auto-update the data range? | Excel Discussion (Misc queries) | |||
update the underlying data source of a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions |