Hi All

I have a quite complex report with about 15 charts fed by sheets with
loads of database functions. (DCOUNTA, DSUM, etc)

I have noticed that sometimes when I change the range names that drive
the analysis (i.e. the month, sales person etc) that some charts
refuse to refresh and show the new data.

That is, when I look at the data worksheet that the chart is based on
the data is updated correctly. However the chart is still showing the
old data before the most recent recalculation.

Is there a way to tell the charts(or a chart) to refresh and ensure
that it is showing the latest data? Ideally I would like to be able to
do this from VB.

Thanks for any ideas in advance.
Chrisso