Update to Named Range not Recognized by Pivot Table Wizard

[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 solution, but that's not
solution for me. I add new rows to a database. I update the rows included
in a named range for the database. I use this named range when running the
pivot table wizard (to create a brand new pivot table). The resulting pivot
table fails to recognize the new (i.e., added) rows of the database. I've
een doing this monthly routine for 12 years with all versions of Excel, and
it worked fine. With Excel 2007, it no longer works. It only picks up the
rows as the named range was originally defined.

Even when I delete the named range from the list of names, and then redefine
it with all rows of the database (including the new rows), creating a new
pivot table with the wizard STILL includes the old rows, none of the new
rows.

What do I now have to do differently with Excel 2007 that none of the prior
Excel versions required me to do so that pivot table wizard includes ALL of
the rows in a named range, not just the rows originally defined?

Thanks.
Ed

 

[JoAnn Paules]

I would suggest posting your question in an Excel-specific newsgroup instead
of a misc Office one. (I'm still trying to understand what a pivot table is
and when I'd want to use one.)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

 

[Ed K]

Hmmm, I'm reading dozens of posts about pivot tables in the Office newsgroup.
I'm looking at your reply and there are dozens of other threads underneath
it with pivot table in the subject line.

I'll go to Excel newsgroup. Am I seeing something you're not?

I would suggest posting your question in an Excel-specific newsgroup instead
of a misc Office one. (I'm still trying to understand what a pivot table is
and when I'd want to use one.)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

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 solution, but that's not
solution for me. I add new rows to a database. I update the rows
included
in a named range for the database. I use this named range when running
the
pivot table wizard (to create a brand new pivot table). The resulting
pivot
table fails to recognize the new (i.e., added) rows of the database. I've
een doing this monthly routine for 12 years with all versions of Excel,
and
it worked fine. With Excel 2007, it no longer works. It only picks up the
rows as the named range was originally defined.

Even when I delete the named range from the list of names, and then
redefine
it with all rows of the database (including the new rows), creating a new
pivot table with the wizard STILL includes the old rows, none of the new
rows.

What do I now have to do differently with Excel 2007 that none of the
prior
Excel versions required me to do so that pivot table wizard includes ALL
of
the rows in a named range, not just the rows originally defined?

Thanks.
Ed

 

[Bob Buckland ?:-\)]

Hi Ed,

You may want to also post this in the MS Excel Table discussion group using the link below. When posting there include whether you
have applied Office 2007 Service Pack 1.

===========
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 solution, but that's not
solution for me. I add new rows to a database. I update the rows included
in a named range for the database. I use this named range when running the
pivot table wizard (to create a brand new pivot table). The resulting pivot
table fails to recognize the new (i.e., added) rows of the database. I've
een doing this monthly routine for 12 years with all versions of Excel, and
it worked fine. With Excel 2007, it no longer works. It only picks up the
rows as the named range was originally defined.

Even when I delete the named range from the list of names, and then redefine
it with all rows of the database (including the new rows), creating a new
pivot table with the wizard STILL includes the old rows, none of the new
rows.

What do I now have to do differently with Excel 2007 that none of the prior
Excel versions required me to do so that pivot table wizard includes ALL of
the rows in a named range, not just the rows originally defined?

Thanks.
Ed>>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Ed K]

Thanks, I'll give the table discussion group a try.

Ed