How to refresh a pivot table that uses changing source data

M

Mike C

Hello - I have figured out how to create a range to allow for dynamic
data sets so that my pivot table can refresh, even when the column or
row size change.

However, when I try to refresh my existing pivot table (by either
clicking the exclamation point, or by going back into the Pivot table
wizard), it doesn't seem to read my source data appropriately. That
is, the dates (which I have displayed as column headers in the pivot
table) 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 of data into the source
spreadsheet, and then clicking refresh in the Pivot table, which I
have on a separate tab.

Thanks for any suggestions!
 
M

Mike C

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top