• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1146
  • Last Modified:

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
0
Lou Dufresne
Asked:
Lou Dufresne
1 Solution
 
als315Commented:
You can go to "Options" Tab and select "Change Data Source":
Options TabYou will be able to change data range

PS. In Excel 2013 place was changed again (Thanks to MS):
http://www.techonthenet.com/excel/pivottbls/data_source2013.php
http://office.microsoft.com/en-ca/excel-help/change-the-source-data-for-a-pivottable-HA102840036.aspx
0
 
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
Perfect Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now