If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot tables after Excel 97
I do a lot of work with pivot tables. Excel versions up to and
including Excel 97 allowed me to copy various formulas using pivot table data the same way one ordinarily copies formulas; the cell addresses that were recorded by clicking on pivot table cells were relative rather than fixed. The new "get pivot data" functions which are automatically generated generate formulas which will not adjust as they are copied. This is a real problem for the kind of work I do. I know that I can get around this by "killing" the pivot table, i.e. doing copy paste special values, but often this is not something that I want to do. Does anyone have any other suggestions? Many thanks |
#2
|
|||
|
|||
Pivot tables after Excel 97
I give the values of the Pivot Table a defined name,
say ArrayPT, then refer to it with INDEX(). The second column of a PT would then be this array formula: =INDEX(ArrayPT,,2) |
Thread Tools | |
Display Modes | |
|
|