This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Excel 2007. My pivot table is using Table1 for the data source. When I add new rows to the table, the pivot table does not include that data. I am using Refresh All.
When I first created the pivot table it did seem to update correctly. My table has 2824 rows currently. What can I look for?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
I figured it out from our last few posts. When the dates were grouped using Group Field - there is a choice to tell it 'Starting at:' and 'Ending at:' I unchecked both boxes and it seems to be working now.
Under Change Data Source - Change data source... I see Select Table/Range: Table1
click anywhere in the pivot table, at the top click on pivottable tools,under data click on change data source, what do you see, is the whole range of your data including the added information included
Technically no. My Data Source is 'Table1' so there is not a way of changing the range that I am aware of. (I am a noob.)
Hi, when you add new data are you changing first the Data source range before clicking on the refresh button ?