I dont think there is a setting that does that. There has been many
occassions where I've had formulas read off a pivot table to compensate for
the lack of presentational ability in the pivot table. Even though the
getpivotdata function does not copy down, formula lookup can still work by
typing in the cell reference instead of linking dirctly to one of the cells
inside the table. In this manner you can convert the pivot table to any
format you want and remain dynamic. Usually I'll use cells to the right of
the pivot table, but its probably better to use another sheet in case the
width of your table needs to be dynamic as well.

hth,
Dave

"Soapydux" wrote:

yes it needs to remain dynamic, just wondered if there was a setting