Pivot Table with Define name

A

Alan Tang

Hello:

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

Thanks!
 
D

Debra Dalgleish

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