ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Refresh not working properly (https://www.excelbanter.com/excel-discussion-misc-queries/255644-pivot-table-refresh-not-working-properly.html)

Satish

Pivot Table Refresh not working properly
 
I have a Raw data sheet where I keep appending the data... When I refresh the
pivot table its not fetching the newly added rows. I checked the data range
which is absolutely fine. If i create a new pivot table the newly added rows
appear in it, but the existing Pivot is not pulling the data set when
refreshed. Any specific reason? I am using Excel 2007. Please help.

Thanks in advance.

Thanks,

Satish

Ms-Exl-Learner

Pivot Table Refresh not working properly
 
Check the Source Data of your Pivot Table whether its covering the new data
range also.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Satish" wrote:

I have a Raw data sheet where I keep appending the data... When I refresh the
pivot table its not fetching the newly added rows. I checked the data range
which is absolutely fine. If i create a new pivot table the newly added rows
appear in it, but the existing Pivot is not pulling the data set when
refreshed. Any specific reason? I am using Excel 2007. Please help.

Thanks in advance.

Thanks,

Satish



All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com