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