Debra,

Sorry for the late response but this is very helpfull. Thanks

Aad (The Netherlands)

"Debra Dalgleish" wrote:

There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html


Aad wrote:
When I currently refer to a cell in the pivot table I get the whole
"=Getpivot...."string while I used to get only a cell reference.

Do you know what I do wrong.

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html