trouble with copy and pivot table

[Ravi Pendakur]

When I tried to reference a cell in a pivot table (for
example in cell e16, I put "=L126", which is part of a
pivot table), I got the following reference:

=GETPIVOTDATA("Std.
Err.",$L$126,"model","Montreal","quantile","q80","variable"
,"Aboriginal")

When I try to copy this reference, it stays an an absolute
reference instead of a relative reference, even after
removing the "$" from $L$126.

Usually this does not happen -- referencing a cell in a
pivot table is just like referencing any other cell.

Is there a way to get back to the normal reference?
thanks
ravi

 

[Govind]

Hi,

How is your pivot organised ?

The getpivot data picks the data from the pivot which matches the
conditions ""model","Montreal","quantile","q80","variable"

,"Aboriginal".So even if you make the L126 an relative reference,

unless and until you change the conditions listed above, it will return
you the same value only.Once you change the conditions, it doesnt matter
if L126 is an absolute or relative reference.

Regards

Govind.

 

[Guest]

The pivot table draws data from a 5 column array (region,
quantile, variable, coefficient, SE). I only want about
1% of the array -- but some stuff from 4 of the columns.

The pivot table is setup so that quantile is on the row
and region and variable are on the column. Coefficient
and SE are in the table. I am trying to copy the
coefficient and SE information over to another part of the
table. The odd thing is , that before yesterday, when I
did a copy (ie: =037), it would just use a cell reference
rather than a pivot table reference. This is the first
time I have encountered this in about 8 years of using
pivot tables
thanks
ravi