hi

i am using a pivot table to produce a report on data, the data range changes on every report run. I tried to point excel to a range (i calculate the range properly and show it as a string in the cell) with the indirect() but it seems that excel wont take this. Is there another way?

thx