Sorry,

You were correct. I was looking at a customer which did not have any data in
the pivot table.

Thanks a bunch
Winnie

"TomPl" wrote:

I think this formula would do the job:

=(GETPIVOTDATA("Sum of Qty",'Y:\Spares sales\[2008.xls]2008
Table'!$A$5,"Customer Name",$B5))

Tom