Hi All,

I have a dilemma. I'll explain the whole story. I have a spreadsheet which
has two pivot tables.
The first is a pivot table that has employees down the left, week numbers
across the top and a count of call number in the data area.
The second pivot is the same however has a field avoidable in the page area
which is set to Yes.
on the third sheet I have a table with all the employees on the left, the
week numbers across the top and the formula:

GETPIVOTDATA("Call Ref",'Avoidables by Person'!$B$5,"Advisor",$A7,"Week
No",B$6)

As the week numbers change I've referenced that value in B6 so if I look on
3 weeks it will go through B6, C6 & D6 etc.

This function was working with Excel 2003 however fails in Excel 97. Does
anybody know why?

--
Adam
-----------
Windows 98 + Office Pro 97

I have Excel 2000 on this machine, and GETPIVOTDATA only has 2 arguments
here, pivot_table and name. I don't have 2003, but if that can take 4
arguments, it seems the function has been enhanced, and 97 just doesn't
support those extra arguments.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Adam" wrote in message
...
Hi All,

I have a dilemma. I'll explain the whole story. I have a spreadsheet which
has two pivot tables.
The first is a pivot table that has employees down the left, week numbers
across the top and a count of call number in the data area.
The second pivot is the same however has a field avoidable in the page
area
which is set to Yes.
on the third sheet I have a table with all the employees on the left, the
week numbers across the top and the formula:

GETPIVOTDATA("Call Ref",'Avoidables by Person'!$B$5,"Advisor",$A7,"Week
No",B$6)

As the week numbers change I've referenced that value in B6 so if I look
on
3 weeks it will go through B6, C6 & D6 etc.

This function was working with Excel 2003 however fails in Excel 97. Does
anybody know why?

--
Adam
-----------
Windows 98 + Office Pro 97

Bob is correct. The GETPIVOTDATA hass been altered as of Excel 2002.
You can look at this web page for a quick run down:
http://www.contextures.com/xlPivot06.html

tj

"Adam" wrote:

Hi All,

I have a dilemma. I'll explain the whole story. I have a spreadsheet which
has two pivot tables.
The first is a pivot table that has employees down the left, week numbers
across the top and a count of call number in the data area.
The second pivot is the same however has a field avoidable in the page area
which is set to Yes.
on the third sheet I have a table with all the employees on the left, the
week numbers across the top and the formula:

GETPIVOTDATA("Call Ref",'Avoidables by Person'!$B$5,"Advisor",$A7,"Week
No",B$6)

As the week numbers change I've referenced that value in B6 so if I look on
3 weeks it will go through B6, C6 & D6 etc.

This function was working with Excel 2003 however fails in Excel 97. Does
anybody know why?

--
Adam
-----------
Windows 98 + Office Pro 97