In the PivotTable Analyze tab, you are given the option to give a PivotTable a name, much like a regular table. However, unlike a regular table, this name may not be referenced in any formulas (such as GETPIVOTDATA where one of the inputs is “pivot_table”) and does not appear in […]