Hi,

I'm not aware of any problem with charts refreshing except possibly in 2007.

Just to make sure you can force recalculation by all four of the following
methods (each works differently):

F9 Recalculate all open workbooks
Shift+F9 Calculate active worksheet
Ctrl+Alt+F9 Recalculates all open workbooks regardless of changes
Ctrl+Alt+Shift+F9 Rechecks dependent formulas and then calculates all cells
in all open workbooks, including cells not marked as needing to be calculated.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chrisso" wrote:

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