Hello
As you're using Excel 2007, then convert your range of data into a Table, the formulas will automatically be added when you add a new row of data. Also, if you reference the Table as the Pivot source it too will be dynamic.

Hope this helps.
DBY