Pivot Table Question

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

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
 
Back
Top