On Feb 11, 5:02*pm, Mike C wrote:
Hello - I have figured out how to create a range to allow for dynamicdatasets so that mypivottablecanrefresh, even when the column or
row size change.

However, when I try torefreshmy existingpivottable(by either
clicking the exclamation point, or by going back into thePivottable
wizard), it doesn't seem to read mysourcedataappropriately. That
is, the dates (which I have displayed as column headers in thepivottable) are not accurate.

Does anyone know why this is? *Should I be doing something different?

In case it helps, here is the formula I am using to name the range:

=OFFSET('FL1'!$A$12,0,0,COUNTA('FL1'!$A:$A),COUNTA ('FL1'!$12:$12))

What I have been doing is pasting a new set ofdatainto thesource
spreadsheet, and then clickingrefreshin thePivottable, which I
have on a separate tab.

Thanks for any suggestions!

Has anyone encountered the problem I mentioned above? Is it just me?