Adaptable Pivot Tables

  • Thread starter Thread starter Allenx
  • Start date Start date
A

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