Hi,

I wonder if anyone can help me with the following problem:

I am using Microsoft Excel 2003. There are several charts in the worksheet and the ranges for the series in the charts are defined by named ranges, e.g.:

Values: =FirstNamedRange

where FirstNamedRange is defined as Sheet1!A2:A100.

The values in FirstNamedRange are themselves calculated from other inputs. The problem is that when I recalculate the sheet, changing the values of FirstNamedRange, there are times when the chart does not change.

This happens sporadically. 9 times out of 10 both the values in the range and the chart change. At other times, the values in the range change and the chart doesn't reflect this. If I save the file, close and then reopen, (thus forcing the chart to recalculate?) then the chart looks correct.

I have tried everything I can think of to remedy this, can someone please help!!

Many thanks