Formula to show PivotTable Name

[pbody]

Is there a way to show the PivotTable name in an individual cell?

I know each PivotTable has it's own name, by default it's PivotTable1, PivotTable 2, etc.

So I want to be a sanity check by reviewing the total volume number in each PivotTable to ensure all the PivotTables are set up correctly.

So want to be able to make my sanity check works, I want to be able to reference each PivotTable name.

I saw some VBA language, but trying to keep it simple.....gotta think there is one but can't find it.

 

[RoryA]

You'd need VBA for that.

 

[pbody]

WTH Microsoft Excel engineers