A
August West
Hi all; I hope someone can help me with this.
I have a database of daily rainfall measurements in the form of a list
managed by the List Manager in Excel 2004. I summarize this using a
pivot table, and a chart made from the pivot table. The data table is
named "Database", but the List Manager's name for the list is
"Rainfall". As it is, the pivot table's source data is a reference to
"Database". This means that whenever I add more data, I have to
redefine "Database" to include the new row(s).
I thought I could get around this by using "Rainfall" as the pivot
table's data source, because the List Manager automatically increases
the size of the list as I add new data. The pivot table wizard will not
accept the list name as a valid reference, however. Is there a way to
use list names for pivot table sources, and in other formulae (such as
DSUM()) so that the reference is automatically updated as values are
added to the database?
I hope my explanation of the problem is clear. Thanks for any help.
I have a database of daily rainfall measurements in the form of a list
managed by the List Manager in Excel 2004. I summarize this using a
pivot table, and a chart made from the pivot table. The data table is
named "Database", but the List Manager's name for the list is
"Rainfall". As it is, the pivot table's source data is a reference to
"Database". This means that whenever I add more data, I have to
redefine "Database" to include the new row(s).
I thought I could get around this by using "Rainfall" as the pivot
table's data source, because the List Manager automatically increases
the size of the list as I add new data. The pivot table wizard will not
accept the list name as a valid reference, however. Is there a way to
use list names for pivot table sources, and in other formulae (such as
DSUM()) so that the reference is automatically updated as values are
added to the database?
I hope my explanation of the problem is clear. Thanks for any help.