Hi Claire

I wonder whether it is getting confused because of the spaces in Uk
Government Gilts.

Try
=GETPIVOTDATA($s$4,"UK GOVERNMENT GILTS" &" " & "ADJ PRINC ")
If that doesn't work, you can email me a copy of the file direct if you like
and I will take a look. Remove NOSPAM from my email address to send direct.


Regards

Roger Govier


weeclaire wrote:
Thanks Roger

I've given this a go however still having a few problems, upon typing
in the formula I am getting N/A.

As an example the pivot table I'm testing on is held in cells S4 to
Y45.
It is the sum of adj princ which is returned in the main body, the
column headers are BNDT, BOXT, CDST, DEPP, (blank), grand total. The
rows can change but there are some standard rows for example UK
GOVERNMENT GILTS, this is one of the rows I am trying to extract data
from.

The formula I have typed is:
=GETPIVOTDATA($s$4,"UK GOVERNMENT GILTS ADJ PRINC")

I am using excel 2000.

Regards
WeeClaire