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

thanks

Richard


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.

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