I Have just switched to using Excel 2010 (from 2003) and I am having difficulty in changing the data range for a pivot table when I have added further data at the bottom. In 2003, you could right click within the pivot table and use the 'Pivot Table Wizard' to do this but I cannot see anytning similar in 2010.

I am getting around this by inserting additional rows in the middle of the data and then pasting the new data in these cells, but this seems a really long winded way of doing it.

I am missing something here?