Dynamic data ranges in pivot tables

[Grey Old Man]

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.

 

[Charles Williams]

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

 

[Grey Old Man]

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

 

[Charles Williams]

It works Ok for me.

Have you refreshed the Pivot Table before using the wizard?