Prev: Pop up reminders
Next: Formulae needed
From: Satish on 8 Feb 2010 07:04
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
From: Ms-Exl-Learner on 8 Feb 2010 08:00
Check the Source Data of your Pivot Table whether it's 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
 | 
Pages: 1
Prev: Pop up reminders
Next: Formulae needed