Solved

MS Excel 2013 - Adding a new row to data to an existing datasheet and have it display in the pivot table

Posted on 2014-04-18
2
1,098 Views
Last Modified: 2014-04-18
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
Comment
Question by:Lou Dufresne
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 40009409
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
 
LVL 1

Author Closing Comment

by:Lou Dufresne
ID: 40009635
Perfect Thanks
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question