Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Smart Tags in Excel fails to recognize stock symble OI. | Excel Discussion (Misc queries) | |||
Pivot Table Wizard Error (Expected 52) | Excel Discussion (Misc queries) | |||
Right Click Pivot table - Wizard - Back button is disable | 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) |