Prev: How do I get to change my xl document in to readable text or numbe
Next: How to rename the head A,B,C,D,E etc. on every column
From: Grey Old Man on 18 May 2010 05:32
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.
From: Charles Williams on 18 May 2010 07:39
Is your Dynamic range dynamic for both rows and columns, or just rows?

<GreyOldMan(a)discussions.microsoft.com> 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.
From: Grey Old Man on 18 May 2010 08:27
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.
From: Charles Williams on 19 May 2010 13:41
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.
 | 
Pages: 1
Prev: How do I get to change my xl document in to readable text or numbe
Next: How to rename the head A,B,C,D,E etc. on every column