Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the pivot table to auto-update the data range?
I've created some pivot tables that rely on the data source, but the range of
data in my data source changes frequently (not just the data in the range, but the range is constantly growing). How can I set the pivot table to automatically "get" all the data when it refreshes - not just changes to data in the range I previously defined? Is this something that can be done, or a limitation in Excel. By the way, I'm using Excel 2002. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the pivot table to auto-update the data range?
You can base the pivot table on a dynamic range, as described he
http://www.contextures.com/xlPivot01.html Toni @ Fidelity wrote: I've created some pivot tables that rely on the data source, but the range of data in my data source changes frequently (not just the data in the range, but the range is constantly growing). How can I set the pivot table to automatically "get" all the data when it refreshes - not just changes to data in the range I previously defined? Is this something that can be done, or a limitation in Excel. By the way, I'm using Excel 2002. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the pivot table to auto-update the data range?
Thank you so much! This was very helpful. I'll be sure to bookmark your
site, it's most helpful. Toni "Debra Dalgleish" wrote: You can base the pivot table on a dynamic range, as described he http://www.contextures.com/xlPivot01.html Toni @ Fidelity wrote: I've created some pivot tables that rely on the data source, but the range of data in my data source changes frequently (not just the data in the range, but the range is constantly growing). How can I set the pivot table to automatically "get" all the data when it refreshes - not just changes to data in the range I previously defined? Is this something that can be done, or a limitation in Excel. By the way, I'm using Excel 2002. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the pivot table to auto-update the data range?
You're welcome! Thanks for letting me know that it helped.
Toni @ Fidelity wrote: Thank you so much! This was very helpful. I'll be sure to bookmark your site, it's most helpful. Toni "Debra Dalgleish" wrote: You can base the pivot table on a dynamic range, as described he http://www.contextures.com/xlPivot01.html Toni @ Fidelity wrote: I've created some pivot tables that rely on the data source, but the range of data in my data source changes frequently (not just the data in the range, but the range is constantly growing). How can I set the pivot table to automatically "get" all the data when it refreshes - not just changes to data in the range I previously defined? Is this something that can be done, or a limitation in Excel. By the way, I'm using Excel 2002. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table - New Data | Excel Discussion (Misc queries) | |||
external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
Pivot table format changes if value of source data is null | Excel Discussion (Misc queries) | |||
Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) |