Hi,

I have

- File A: an excel file with the 'data master'
- File B[1..n] one (and later several) files referencing the data in file 1 using a namerange.

All files B shall at a later point reference the data in File A via a pivot table.

I have created the first file B and created a name range in File B called MasterDataLookup referencing the data area in file A.

Now I would like to use that namerange in File B within a pivot table in file B.

Is that possible?
So far I can´t find a way to get it to work.

Thanks for any help.