Pivot Table Wizard Fails to Recognize New Rows of Database

[Ed K]

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.

 

[Shane Devenshire]

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]

Hi Shane,

Yes, a range of columns (fields) and rows (records) in Excel. If I insert a
new column (i.e., new field) into a the database, then create a pivot table
from scratch, the pivot table wizard does not offer up the new field as one
of the fields in its windows.

Similarly, when I add new rows (i.e., records in the database), update the
named range to include the new rows, then build a new pivot table, the pivot
table does not recognize the new rows.

If I used CTRL-T, I still need a named database in the pivot table wizard.
R u saying that the named range will automatically update when I add new
rows? If so, the pivot table wizard still would not recognize the new rows
of the named database.

This was so very simple with 3 prior Excel versions -- the pivot table
wizard recognized added rows and added columns in a named range. Not anymore
with Excel 2007. I'm guessing that I am missing something very basic. Any
idea what it is that I am missing?

Thanks.

Ed