I am good with the getpiviotdata function.. but not sure how i would
pull data from a piviot table that is in workbook1 and assign the
value to a variable (lets say variable temp) i have in my code.

can anyone help me with this please

Thanks,