Cannot modify formula

  • Thread starter Thread starter Eva Shanley
  • Start date Start date
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)))
 
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).
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top