I want to copy a formula that uses cells within a pivot table. The formulae that are pasted are exactly the same as the formula that was copied getpivotdata references do not change. The next row data is not used in the formula. I'm using Home version so do not have power pivot with calculated fields possibilities.

Any ideas would be much appreciated.

Paul