I have a pivot table which includes a Grand Total column (currently in column AU). I want to create a named range (Grand_Total_Column) for the column that contains the Grand Total that will move with the column as the pivot table expands.
Grand Total is in row 3.
I have tried using this formula in the Refers To box
but this did not work.