Hi,
Is there any way a pivot table value can still be traced with the getpivottable function when the field is not available in the pivotdisplay ?
See the retional lookup works when the field is displayed, but not if the field is not displayed. see cell a36 and f36
See the enclosed sheet
Greetings,
Jack:spin: