MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot table annoyance

Posted by Richard Jones on April 12, 2001 5:10 AM

I use a massive, in my terms, pivot table and add data to it each month.

I have tried naming a range for the data to be picked up from i.e. $a:$i, so as it will automatically add new info..on refresh.

The problem i have is i cannot group my data when i use such a range (i.e. days into months)

is there another way



Posted by Dave Hawley on April 12, 2001 6:27 AM

Hi Richard

I know exactly what you mean! If you follow my link to my Webpage you will see a link to "Dynamic Ranges" these are ideal for Pivot Tables and Charts. any problems with them let me know.

OzGrid Business Applications

Posted by Mark W. on April 12, 2001 6:29 AM

Name your range (e.g., Database) and use that range
name at Step 2 of 4 of the PivotTable Wizard.