#1
|
|||
|
|||
Copying a formula that uses pivottable cells
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |
PivotTable | ibrahimaa | Excel | 0 | 06-19-2012 10:11 AM |
Copying cells | isminoh | Excel | 5 | 04-18-2012 11:49 AM |
PivotTable | ibrahimaa | Excel Programming | 1 | 04-15-2012 12:30 AM |
Sum Formula in the range with Numeric and NonNumeric data cells | Spanec | Excel | 2 | 01-12-2012 09:15 AM |