Reference to a value from another object

[#1]

Hi everyone, is there any way to set as a new expression in a pivot table, the value that another pivot table has in a specific cell?

Thanks a lot

[johnw · Accepted solution]

I don't believe so, but would be happy to be proven wrong.

[#3]

Ok Thanks

[wizardo]

hi there,

as far as i know it is only posible via macro code. check the apiguide for the methods: getcell, getcells, getcells2.

i used it once and its bit tricky.

best is if you make a hidden sheet with a copy of the pivot table and get the cells from there.

i did it long ago before set analysis so i had to clear all selections before i copied the cell, since its location changes when you change selections. but maybe with set analysis you can freeze it or at least be able to recalculate the location again.

if you can get the same value from a straight table i think it will be easier.

its very tricky and dirty but sometimes you need it.

Mansyno

[#5]

Ok I´ll try. Thanks.