Named Range Calculated Field Pivot Table

[wsnyder]

Hi all,

Using Excel 365.

I would like to use a Named Range that contains a Tax_Rate in a calculated field
This way, users can easily change the rate on an Input Sheet if the rate should change.
It seems the calculated field does not recognized the Named Range.
What are some other options?

Thanks
-w

 

[GraH]

A possible alternative is using PowerPivot and a disconnected table (advanced application).
One tutorial: SumProduct