Dynamic Named Ranges and Pivot Tables

[lobop3]

I was able to get my Dynamic Named Range table set up. I tried to reference the range in my Pivot Table.

Under the Pivot Table Tab
I clicked change source and a box came up asking for a table or range.
I typed my named range right in the location field.

My Pivot Table went blank
So I tried =named range

and nothing

I can't find anything online about how to refer to a dynamic named range from the pivot table.

What am I missing?

 

[NBVC]

1. Double check that the Named Range is actually working, by going to Formulas|Name Manager, select the Name and then click in the Refers To field where your formula is, and make sure it actually highlights the desired area.

2. While you are there, make sure the Scope is Workbook, so that it can be references from other sheets.

 

[lobop3]

Thanks for your help!!