Excel GetPivotData function in 2010 not working in 2000

[Jed Shields]

Hi guys,

I've got the following function working on my laptop using Excel 2010:

=GETPIVOTDATA("sum of call costs (airtime)",PivotTableCost!$A$3,"user name",A4,"Month",MonthSelect)

However, when I save as a 97-2003 workbook so that I can use it on a PC running Excel 2000 the function doesn't work, it just returns a Values error. From what I've read so far it looks like there is a difference in the structure of the function between 2000 and 2010 versions. Can anyone convert the above function into one that 2000 will recognise?

Cheers,

Jed.

EDIT - just to clarify:

A4 refers to a cell with a specific User Name. User Name column appears in the Pivot Table.
MonthSelect refers to a named range where a Month is selected from a drop down list. Month column appears in the Pivot Table.

 

[Jed Shields]

I've sort of got it working, but I can't find a way of entering a dynamic reference ie instead of typing "2011-Feb" into the formula as the Month reference I'd like to be able to type in $A$1, where $A$1 has a drop down list of Months that I can choose from. Any suggestions?