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

Hi
not tested but the procedure described at
http://www.contextures.com/xlPivot01.html
may also work for additional columns

--
Regards
Frank Kabel
Frankfurt, Germany

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

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

Thanks


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