Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Wizard Fails to Recognize New Rows of a Named Range
Excuse me if you've already have seen this post in another discussion group,
but someone suggested I post my Excel pivot table question here. I've been following the same routine for years, but now Excel 2007 pivot table no longer includes new rows of a named range (i.e., an Excel database) 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 solution, but that's not solution for me. Here's what I am writing about: I add new rows to a database defined in Excel 2007 (columns = fields, rows = records). I then update the named range I have used for years to include these the new rows in. I then use the named range in the pivot table wizard. The resulting pivot table fails to recognize the new rows of the database, even though the named range I gave the pivot table includes the new rows. I've been doing this monthly routine for many years with all versions of Excel, and it has worked perfectly (i.e., the pivot table uses the new definition of the ranged name). With Excel 2007, it no longer works (i.e., the pivot table ignores the new rows, even though the named range clearly includes them). What do I now have to do differently with Excel 2007 that none of the prior Excel versions required me to do? Thanks. Ed |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Wizard Fails to Recognize New Rows of a Named Range
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: Excuse me if you've already have seen this post in another discussion group, but someone suggested I post my Excel pivot table question here. I've been following the same routine for years, but now Excel 2007 pivot table no longer includes new rows of a named range (i.e., an Excel database) 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 solution, but that's not solution for me. Here's what I am writing about: I add new rows to a database defined in Excel 2007 (columns = fields, rows = records). I then update the named range I have used for years to include these the new rows in. I then use the named range in the pivot table wizard. The resulting pivot table fails to recognize the new rows of the database, even though the named range I gave the pivot table includes the new rows. I've been doing this monthly routine for many years with all versions of Excel, and it has worked perfectly (i.e., the pivot table uses the new definition of the ranged name). With Excel 2007, it no longer works (i.e., the pivot table ignores the new rows, even though the named range clearly includes them). What do I now have to do differently with Excel 2007 that none of the prior Excel versions required me to do? Thanks. Ed |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Wizard Fails to Recognize New Rows of a Named Rang
Hi Shane,
That did not work. The pivot table created through the wizard fails to pick up a number of records in the Excel database, including records that are neither the top row or the bottom row of the defined range. When we solve this one, I hope I'm not embarrased at how simple the fix is. No complaints wasting hours on this one -- only a Microsoft issue, not a world event. Ed "ShaneDevenshire" wrote: 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: Excuse me if you've already have seen this post in another discussion group, but someone suggested I post my Excel pivot table question here. I've been following the same routine for years, but now Excel 2007 pivot table no longer includes new rows of a named range (i.e., an Excel database) 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 solution, but that's not solution for me. Here's what I am writing about: I add new rows to a database defined in Excel 2007 (columns = fields, rows = records). I then update the named range I have used for years to include these the new rows in. I then use the named range in the pivot table wizard. The resulting pivot table fails to recognize the new rows of the database, even though the named range I gave the pivot table includes the new rows. I've been doing this monthly routine for many years with all versions of Excel, and it has worked perfectly (i.e., the pivot table uses the new definition of the ranged name). With Excel 2007, it no longer works (i.e., the pivot table ignores the new rows, even though the named range clearly includes them). What do I now have to do differently with Excel 2007 that none of the prior Excel versions required me to do? Thanks. Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Wizard Fails to Recognize New Rows of Database | Excel Discussion (Misc queries) | |||
Data validation drop downs don't recognize dynamic named range | Excel Discussion (Misc queries) | |||
Smart Tags in Excel fails to recognize stock symble OI. | Excel Discussion (Misc queries) | |||
vlookup fails on data from a pivot table | Excel Worksheet Functions | |||
How can I get a pivot table to recognize a growing database? | Excel Discussion (Misc queries) |