Setting a datarange

[Joyce]

Can I set up one datarange (i.e. all the data in worksheet 1) that all my
pivot tables call to?

thx

[Debra Dalgleish]

You could use a dynamic range as the pivot source, and refer to the
range name in the code. There are instructions here:

http://www.contextures.com/xlPivot01.html

Joyce wrote:
> Can I set up one datarange (i.e. all the data in worksheet 1) that all my
> pivot tables call to?
>
> thx


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html