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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adaptable pivot tables 2
Adaptable pivot table ranges 3
Pivot Table Help! 1
Export Pivot table 1
Pivot table report invalid 0
Spreadsheet growth - due to Pivots 4
not your typical Pivot Table Named Range question 7
Consolidate Pivot Tables/Cache using Excel 2003 1

Back
Top