E
Eric
Steve,
You are definitely experiencing one of the strange changes
in Excel between 2000 and 2002. In 2002, if you reference
a cell in a pivot table by clicking on it, you will get
the GETPIVOTDATA function. If you copy that formula,
you'll notice that it always references the same data set
unless you tinker with the variables in the formula. If
you look at the GETPIVOTDATA in Excel's help, you can
probably work through the syntax it uses.
Personally, I use traditional references (i.e. =A1+B2)
because of the compatability problem. Unfortunately
though, you cannot manipulate the pivot table or your
references will pull incorrect data.
Does that help?
Eric
You are definitely experiencing one of the strange changes
in Excel between 2000 and 2002. In 2002, if you reference
a cell in a pivot table by clicking on it, you will get
the GETPIVOTDATA function. If you copy that formula,
you'll notice that it always references the same data set
unless you tinker with the variables in the formula. If
you look at the GETPIVOTDATA in Excel's help, you can
probably work through the syntax it uses.
Personally, I use traditional references (i.e. =A1+B2)
because of the compatability problem. Unfortunately
though, you cannot manipulate the pivot table or your
references will pull incorrect data.
Does that help?
Eric