Hi Ruth
Could you not have that formula as the first row of your Worksheet and then have the Pivot Table, for example, populate from cell A3. That way, irrespective of the size of your pivot table, you would not have to worry about moving that formula?
Hope this helps.
Tony