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