1
is there a way to refer to a pivot table using a range name? I want to have another table with calculations based on what's in the pivot table, but I want to use range names to make sure my calculations are still correct if the size of the pivot table changes.