Make a Pivot Table a named range

[Shay A]

Hi,
Is it possible to name a pivot table as a named range? Rather than using the pivotvtable1 etc. which is a generic name. And also, can I use a hyperlink to a pivot table?

TY

 

[David Evans]

You can make a Pivot Table a Named Range, but the range won't dynamically change as the pivot changes.
You might look at dynamic ranges, which we don't hear a lot about anymore as Excel Tables negated the need for them.

http://forum.chandoo.org/threads/define-dynamic-range-using-index.13561/

There is some other information in there which might relate to your challenge

 

[Shay A]

Thank you,
I guess that also means that if I move picot table to another reference in the worksheet or to another worksheet, the hyperlink doesnt correspond to that chang

TY again

 

[jeffreyweir]

You can use vba to do this as per my guest blog post at http://chandoo.org/wp/2014/10/18/introducing-structured-references-for-pivottables/