Archive of Mr Excel Message Board


Back to Pivot Tables in Excel archive index
Back to archive home

Extend range automatically for pivot table reference

Posted by Debbyy on April 02, 2001 3:23 PM
Entering data in a spreadsheet using a form. Trying to figure out how to have the data range automatically adjust as data is added so that the range used for the pivot table does not have to be updated everytime (refreshing data does not update the range).

Re: Extend range automatically for pivot table reference

Posted by David Hawley on April 02, 2001 3:28 PM


Hi Debbyy

If you follow my link to my website, then click the "Dynamic Named Ranges" link you will see some examples that are probably exactly what you are after.

Dave
OzGrid Business Applications


OR....

Posted by Dave Hawley on April 02, 2001 3:32 PM


If your Pivot Tables are not within the same Workbook as your data you can use some code that I have on my "VBA Tips and Tricks" page. If you run into any problems just let me know.

BTW The "Dynamic Named Ranges" link should have read "Dynamic Ranges"

Dave
OzGrid Business Applications


Re: Extend range automatically for pivot table reference

Posted by Tommy Christensen on April 03, 2001 6:16 AM


Re: Extend range automatically for pivot table reference

Posted by Tommy Christensen on April 03, 2001 6:19 AM

Hi
It is possible, when you select the range just to select the coloums of data to the pivottable. This way you will never have to adjust the range
regards
Tommy


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.