In XP you type the + and select a total cell in the pivot table and XP automatically creates the formula =+GETPIVOTDATA("Sum of June YTD Actuals",$A$70) where the formula in 2000 use to be +C78. A70 is a blank cell. But it works in XP and in 2000 they get #Value!
The plus sign has nothing to do with your #VALUE! error. Your GETPIVOTDATA arguments are in the wrong order. Take a closer look at my recommendation above and see the Excel Help topic for "GETPIVOTDATA worksheet function". This message was edited by Mark W. on 2002-08-29 13:19