Refreshing Pivot tables

[j_Southern]

Hi,
I have a pivot table analysing a dynamic table which I refresh as follows

Please Login or Register  to view this content.

This is a technique I have used, unthinkingly, many times without a problem,using Excel 2000. I now have Excel 2010
After seeing some anomolous results I discovered by looking at the data source that the Pivot was only analysing a portion of the data table.
How can I tell the Pivot that it has to look for the whole of a dynamic table?
John

[OnErrorGoto0]

How is the data source specified?

[Grace14]

Try this

Please Login or Register  to view this content.

by changing the "program title" to the name of your pivot table. Which you can find in options for pivot table.

Does this help?

[Grace14]

by changing the "program title" to the name of your pivot table. Which you can find in options for pivot table.

Does this help?