Adaptable Pivot Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allenx - 16 Oct 2007 18:39 GMT

What is a general technique for handling the follow situation? I use pivot
tables and pivot charts to analyze a dataset. Each week, the dataset's
record count increases (i.e. the number of rows and the size
of the pivot table uses, grows).

> I want to avoid manually re-building the pivot table and pivot charts each
> week and would like the pivot table's range to expand automatically to
> include all records.

> It appears using named ranges in the pivot table definition is not
> allowed. Also, I want to avoid using macros if possible.

Reply to this Message

Ron Coderre - 16 Oct 2007 20:16 GMT

You should be able to base the Pivot Table on a Dynamic Range Name, which
will automatically expand/contract to accomodate the available data.

See this website for instructions:
http://www.contextures.com/xlNames01.html#Dynamic

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

> What is a general technique for handling the follow situation? I use
> pivot
[quoted text clipped - 9 lines]
>> It appears using named ranges in the pivot table definition is not
>> allowed. Also, I want to avoid using macros if possible.

Reply to this Message