I have created a formula in Excel 2003 for getting Pivot Table Data that
doesn't work in 2000. The formula for 2000 seems to be wanting a text string,
but the variable that needs to be looked up everytime is changing...

Here is the formula in 2003:

=IF((OR(D10=0,X10=1)),0,GETPIVOTDATA("Responders", 'Response Pivot
Table'!$C$6,"M Code",Report!A10,"Week",$AB$12))

So, based on the condition, I want the data for responders for a specific M
Code and Week value....those are always changing, so it has to be dynamic.
But, it seems that for 2000 the form is:

'=IF((OR(D10=0,X10=1)),0,GETPIVOTDATA('Response Pivot Table'!C5,"Text
String"))

How do I get the text string if my value always change? I'm stuck and need
some help quick if possible!! I thank you in advance....

You can create the string with cell references, e.g.:

GETPIVOTDATA($C$5,"'" & H11 & "' '" & H12 & "' '" &H13 & "'")

Matt wrote:
I have created a formula in Excel 2003 for getting Pivot Table Data that
doesn't work in 2000. The formula for 2000 seems to be wanting a text string,
but the variable that needs to be looked up everytime is changing...

Here is the formula in 2003:

=IF((OR(D10=0,X10=1)),0,GETPIVOTDATA("Responders", 'Response Pivot
Table'!$C$6,"M Code",Report!A10,"Week",$AB$12))

So, based on the condition, I want the data for responders for a specific M
Code and Week value....those are always changing, so it has to be dynamic.
But, it seems that for 2000 the form is:

'=IF((OR(D10=0,X10=1)),0,GETPIVOTDATA('Response Pivot Table'!C5,"Text
String"))

How do I get the text string if my value always change? I'm stuck and need
some help quick if possible!! I thank you in advance....


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html