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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

name manager to define another workbook 4
Export Pivot table 1
Pivot table from dynamic refreshed pivot table 3
Pivot Table Help! 1
pivot table calculated field 1
Pivot table report invalid 0
Adding a Formula as a data variable in a pivot 5
Defining a table in Excel 2

Top