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.

Dynamic data ranges in pivot tables
 

Is your Dynamic range dynamic for both rows and columns, or just rows?

wrote:

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.

Dynamic data ranges in pivot tables
 

Name=OFFSET('Data'!$A$1,0,0,COUNTA('Data'!$A:$A),C OUNTA('Data'!$1:$1))

"Grey Old Man" wrote:

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.

Dynamic data ranges in pivot tables
 

It works Ok for me.

Have you refreshed the Pivot Table before using the wizard?

Name=OFFSET('Data'!$A$1,0,0,COUNTA('Data'!$A:$A), COUNTA('Data'!$1:$1))

"Grey Old Man" wrote:

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.