I create the getpivotdata outside the report and when I copy the formula, the
cell reference in the getpivotdata function is not relative.

How do I copy the getpivotdata function with the relative cell reference?
--
Thank you... Elaine