Pivot Table with Define name

Hello:

Is it possible to use define name in Pivot Table that the define name is
link to another woeksheet?

Thanks!

You can use a named range in another workbook, if that workbook is open.

Or, in step 1 of the pivot table wizard, select external data source,
and connect to the other workbook.

Alan Tang wrote:
> Hello:
>
> Is it possible to use define name in Pivot Table that the define name is
> link to another woeksheet?
>
> Thanks!


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