Disappearing calc field in pivot table

[werafa]

Hi

I have a pivot table with calculated field.
If I update the source data range, it disappears.

does anyone know why, and how to prevent this?

Thanks
Tim

[Aflatoon]

Do you mean the field disappears from the field list?

[werafa]

yes. it disappears from the pivot table, and the field list, and re-entering the calculation as a new calc field gets boring rather quickly.
The field is calculated as a division of 2 existing fields - neither of which are affected by the changed input field range

[Aflatoon]

How precisely do you update the source data range?

[werafa]

from the change data source button in the pivot table tools tab

[Aflatoon]

Are you simply extending the data range (eg using more rows) or using a different range? I have often seen a calculated field convert to #REF errors when altering the source data but not disappear altogether.

[werafa]

I extend it, or shrink it to remove blank columns (illegal row names). in all cases, the fields going into the calculated fields are completely unaffected (one would think)

it is set up as 'A:AH', and i change it to "A:AI' or 'A:AG'

[Aflatoon]

Strange. Which version of Excel are you using?

[werafa]

tis office 2010.

[werafa]

and just tried to recreate the scenario in a sample worksheet so I could post it, and completely failed......

I have just upgraded to a new lappy on win 7 (was using an older lappy on xp).

I might just have to start calling this a feature instead of a bug....

I'll have one more dig next time I open the sheet, and post what I find. If I find nothing constructive to the thread, I'll call it closed

Thanks for your interest so far anyway