Link to home
Start Free TrialLog in
Avatar of Lou Dufresne
Lou DufresneFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lou Dufresne

ASKER

Perfect Thanks