I have a pivot table in Excel 2010, on a separate sheet from the source data. This separate sheet is in the same workbook.
Now I have added rows in the pivot table, I cannot see in Excel 2010 how to tell the pivot table to pick up the extra rows (I recall in earlier versions that there was an option to change the data source).
Can anyone help?
Many thanks - SA