hi,

I have a formula in cell A2 that references D2. like "=D2". D2 happens to
be part of a pivot table (a grand total). how can I make sure that the cel
reference follows or "chases" when the size of the pivot table decreases or
increases. I want to avoind using GetPivotData if possible

thanks in advance,
geebee

Get pivot data is really the only good option. What is your aversion to
getpivotdata? Perhaps we can work around it...
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

I have a formula in cell A2 that references D2. like "=D2". D2 happens to
be part of a pivot table (a grand total). how can I make sure that the cel
reference follows or "chases" when the size of the pivot table decreases or
increases. I want to avoind using GetPivotData if possible

thanks in advance,
geebee

well lets say you take a grand total for a value that no longer exists in
the table. then it will be wrongly be based on the grand total for something
else, or you will get the error.

"Jim Thomlinson" wrote:

Get pivot data is really the only good option. What is your aversion to
getpivotdata? Perhaps we can work around it...
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

I have a formula in cell A2 that references D2. like "=D2". D2 happens to
be part of a pivot table (a grand total). how can I make sure that the cel
reference follows or "chases" when the size of the pivot table decreases or
increases. I want to avoind using GetPivotData if possible

thanks in advance,
geebee

The error is easy to get around with an IsError formula something like this

=if(iserror(GetPivotData(...)), 0, GetPivotData(...))

The grand total showing the incorrect amount will be more difficult (no
matter whether you use getpivotdata or not) beause it will reflect the result
based on the filters and aggregations you have in place.
--
HTH...

Jim Thomlinson


"geebee" wrote:


well lets say you take a grand total for a value that no longer exists in
the table. then it will be wrongly be based on the grand total for something
else, or you will get the error.

"Jim Thomlinson" wrote:

Get pivot data is really the only good option. What is your aversion to
getpivotdata? Perhaps we can work around it...
--
HTH...

Jim Thomlinson


"geebee" wrote:

hi,

I have a formula in cell A2 that references D2. like "=D2". D2 happens to
be part of a pivot table (a grand total). how can I make sure that the cel
reference follows or "chases" when the size of the pivot table decreases or
increases. I want to avoind using GetPivotData if possible

thanks in advance,
geebee