Pivot Table Wizard Fails to Recognize New Rows of Database
Hi,
When you say database, do you mean a range in Excel? Simple solution if
that is what you mean is to ignore the range name and define the range as a
table. To do that select the data and press Ctrl+T (or Ctrl+L), then click
OK. The pivot table will use the table. As you add new data to the
database the pivot table will automatically extend.
cheers,
Shane
"Ed K" wrote in message
...
Been following the same routine for years, but Excel 2007 pivot table no
longer includes new rows AFTER I update the rows/columns included in the
named range I use in the pivot table wizard.
I've seen the other posts here with =OFFSET as a solutino, but that's not
solution for me. I add new rows to a database. I update the rows included
in
a named range of the database. I use the named range in the pivot table
wizard. The resulting pivot table fails to recognize the new rows of the
database. Been doing this monthly routine for 12 years with all versions
of
Excel, and it worked fine. With Excel 2007, it no longer works.
What do I now have to do differently with Excel 2007 that none of the
prior
Excel versions required me to do?
Thanks.
|