Cannot modify formula

E

Eva Shanley

Hi,
I need to modify a formula in a spreadsheet created in XP;
I'm making the changes in Excel 2000. I get a message
saying there's an error in the formula when I enter it.
The formula seems to return the correct data when the file
is opened in 2000, I just can't edit it. I wondered if
anyone knew why; I've included the formula below. The
highlighted word in the formula bar is "Sub Segment".
Thanks for all your help.

=IF(AM$6=0,0,IF(ISERR(GETPIVOTDATA("Sum of
Present",Pivot1H!$A$2,"Sub
Segment",$A9,"CountPromo",$E9,"Week2",OFFSET
(PlanMonths7to12,0,AM$6,1,1))),IF($E9="Turn",1,""),IF
(GETPIVOTDATA("Sum of Present",Pivot1H!$A$2,"Sub
Segment",$A9,"CountPromo",$E9,"Week2",OFFSET
(PlanMonths7to12,0,AM$6,1,1))>0,1,0)))
 
J

Jim Rech

The GETPIVOTDATA function is not one I've used but looking at Help for it in
Excel 2000 shows this syntax:

GETPIVOTDATA(pivot_table,name)

while in Excel 2002 it shows:

GETPIVOTDATA(data_field,pivot_table,field1,item1,field2,item2,...)

So it appears that Microsoft has enhanced it in Excel 2002 and you'll have
to find another way to get the result you want in 2000. (Can't help you
there).
 
E

Eva Shanley

Jim, thanks for the response. I knew I should have
checked the formula in 2000, but never really thought it
would have changed. I'll remember to check next time.
 
Top