Pivot Table Range

[Dnyan]

Hi,


I preapared a Pivot Table and then i add some data in it but now all data is not showned by Pivot Table.

I do all necessary things like refresh and all but unable to increase a range.

so pls tell me how to increase range for Pivot Table in 2007.

Regards,
Dnyan

[VKS]

Hello Dnyan,
You will have to change the source data range by:
1. Click anywhere on your pivot table
2. Go to options tab
3. Click on change data source
4. Now included the new lines (You will see excel highlights only the previously selected rows)
Once you have changed the data range for Pivot table refresh it and you will see new items included in it.

Hope this helps. Best Regards/VKS

[Dnyan]

Hi,

Yes it's works.


Thank you very much

Regards,
Dnyan

[VKS]

Hello Dnyan, If you think it helped how about clicking that star at the bottom left of my post.
Best Regards/VKS