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!
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!