Pivot table missing data from a named range

[Maxime]

Hello,
I'm using Excel 2010 and I have an issue with a Pivot table.
I'm creating a pivot table from a named range called "Range_LgLossTriangle" but only 10% of the data are shown in my pivot table, if I hit Change Data Source and put the address of the named range instead of the name of the range, it works fine.
Is this a known issue?

I've checked that the name's scope is the whole workbook, and there is no name conflict.
Any ideas?

Thank you,
Maxime

 

[ghrain22]

That should work. Double check that your named range is grabbing the correct range.

 

[Maxime]

Yes that should definitely work, but I can't figure out why it doesn't. I've double checked that the named range is grabbing the correct range.
I've even tried with a vlookup to see if the named range is ok. That's so strange.

 

[ghrain22]

try removing the named range and renaming it.