Pivot Table Source Data Named Range

[JoeExcelHelp]

I have 2 WB's (A, B)
WB-B contains a Named Range (Table1)
I would like to reference this Named Range as the source data for a Pivot Table in WB-A
Using Excel 2013

Thank You

[HansV]

Open both A and B.
Activate A.
Select the top left cell of where you want the pivot table to be.
On the Insert tab of the ribbon, click Pivot Table.
Click in the Table/Range box under "Select a table or range", then switch to B, and select the named range.
Click OK.
Proceed as usual.
Save and close B first, then A.

[JoeExcelHelp]

Thanks Hans,
I'm trying this in 2010 at the moment
when I open the PivotTable Table/Range within WB A and then proceed to select the Named Range within WB B no data at all populates within the Table/Range bar
Is this a 2013 only feature?

[HansV]

Is it a 'static' named range, or a 'dynamic' named range (i.e. one that grows/shrinks automatically as data are added or deleted)?

[JoeExcelHelp]

Statis, I simply highlight the range and name it

[HansV]

Works for me in Excel 2010:

1) Insert Pivot Table dialog:

S243.png

2) Result:

S245.png

[JoeExcelHelp]

Really odd.. doesnt work for me just remains blank
However if I use a ramge within the same WB-A it captures the range no problem
Thanks Hans

[HansV]

Sorry, can't explain that. If you wish, you can attach a stripped down copy of the "source" workbook.