PDA

View Full Version : Disappearing calc field in pivot table



werafa
02-27-2013, 02:55 AM
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
02-28-2013, 06:07 AM
Do you mean the field disappears from the field list?

werafa
03-03-2013, 10:21 PM
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
03-03-2013, 11:36 PM
How precisely do you update the source data range?

werafa
03-04-2013, 03:51 PM
from the change data source button in the pivot table tools tab

Aflatoon
03-05-2013, 02:19 AM
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
03-05-2013, 04:19 PM
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
03-06-2013, 01:52 AM
Strange. Which version of Excel are you using?

werafa
03-06-2013, 03:30 PM
tis office 2010.

werafa
03-06-2013, 03:43 PM
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