MS Excel 2013 - Adding a new row to data to an existing datasheet and have it display in the pivot table
My issue: I am adding a row to the data used by a pivot table and then having it displayed in the pivot table reports.
However, when I add the data as the next row in my Excel datasheet and then refresh the pivot table the data does not appear in the pivot table.
How do I increase the existing Pivot table range to include newly added rows of data?
Where do I do this in Excel?
How do I set up a new pivot table to include all rows added to appear in the pivot table?