Adaptable Pivot Tables

[Allenx]

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).

 

[Ron Coderre]

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)