View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Grey Old Man[_2_] Grey Old Man[_2_] is offline
external usenet poster
 
Posts: 24
Default Dynamic data ranges in pivot tables

I am using Excel 2002. I have defined a dynamic data range and am using it in
a pivot table, which works OK.

I have added a new column to the data range, but when I use the pivot table
wizard to update the layout, the new column is not available.

If the range is dynamic, why wont it accept new data?

Thanks in anticipation.