Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adaptable pivot table ranges
What is a general technique for handling the
follow situation? I use pivot tables and pivot charts to analyze a dataset. Each week, the dataset's record count increases (thus the rows the pivot table uses expands). I want to avoid manually re-building the pivot table and pivot charts each week and would like the pivot table's range to expand automatically to include all records. It appears using named ranges in the pivot table definition is not allowed. Also, I want to avoid using macros if possible. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adaptable pivot table ranges
If you are not looking for a Macro solution then perhaps the programming area
is not the best place to post. That being sid it can be done without macros so that would have been my suggested solution anyways... Check out this link... http://www.contextures.com/xlPivot01.html -- HTH... Jim Thomlinson "Allenx" wrote: What is a general technique for handling the follow situation? I use pivot tables and pivot charts to analyze a dataset. Each week, the dataset's record count increases (thus the rows the pivot table uses expands). I want to avoid manually re-building the pivot table and pivot charts each week and would like the pivot table's range to expand automatically to include all records. It appears using named ranges in the pivot table definition is not allowed. Also, I want to avoid using macros if possible. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adaptable pivot table ranges
Define the pivot table using the entire column instead of specific rows and
then turn off the value "(blank)" Peter Richardson "Allenx" wrote: What is a general technique for handling the follow situation? I use pivot tables and pivot charts to analyze a dataset. Each week, the dataset's record count increases (thus the rows the pivot table uses expands). I want to avoid manually re-building the pivot table and pivot charts each week and would like the pivot table's range to expand automatically to include all records. It appears using named ranges in the pivot table definition is not allowed. Also, I want to avoid using macros if possible. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adaptable pivot table ranges
That will work so long as you are not trying to group the data by date as
blanks will prevent the grouping... -- HTH... Jim Thomlinson "barnabel" wrote: Define the pivot table using the entire column instead of specific rows and then turn off the value "(blank)" Peter Richardson "Allenx" wrote: What is a general technique for handling the follow situation? I use pivot tables and pivot charts to analyze a dataset. Each week, the dataset's record count increases (thus the rows the pivot table uses expands). I want to avoid manually re-building the pivot table and pivot charts each week and would like the pivot table's range to expand automatically to include all records. It appears using named ranges in the pivot table definition is not allowed. Also, I want to avoid using macros if possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Ranges | Excel Discussion (Misc queries) | |||
Pivot Table Data Ranges | Excel Discussion (Misc queries) | |||
Help with Selecting Ranges in Pivot Table | Excel Programming | |||
Pivot Table - consolidating ranges (again) | Excel Discussion (Misc queries) | |||
using date ranges in a pivot table | Excel Programming |