Check out Debra Dalgleish's site:
http://www.contextures.com/xlNames01.html#Dynamic

She has instructions on how to create a dynamic range names.



Joyce wrote:

I have a pivot table that is based on a source worksheet. I'm continually
adding lines to the source worksheet and have to keep changing the range in
the pivot table. Is there a way to set it permanently to be "all the data in
the source worksheet"? (My workaround is setting it at 65000 but I'm not
sure whether it's hogging memory by doing that).

Thanks

--

Dave Peterson