I posted something a little while back but I think it was to
complicated for a response. Not sure what the protocol on this is (i
it still double posting if its clearer?). Thought I would instead as
a simple question?

Is it possible to update a pivot table's data fields using a dynami
range? I know I can refresh it using a dynamic range with new data an
no change in range dimensions. But I don't know how to update the dat
fields if the data AND the dimensions of the dynamic range change.

Thank

--
Message posted from http://www.ExcelForum.com