Lou Dufresne
asked on
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.
Questions:
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?
Any Assistance will be appreciated.
Ldufresne
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.
Questions:
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?
Any Assistance will be appreciated.
Ldufresne
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER