Owen,

You need to type the cell reference into the formula rather than using cell selection to pick up the
cell. Clicking on a cell in the pivot table defaults to the GETPIVOTDATA function....

HTH,
Bernie
MS Excel MVP


"Owen Peck" <Owen wrote in message
...
I want to perform a calculation on data in a pivot table which I then copy
down row by row but when I copy the formula down it does not work as it picks
up the criteria in the first row of the pivot table.

In old versions of Excel it just copied the simple formula down as opposed
to putting in the pivot table criteria - how do I replicate this?