Excel 2007 Chart auto update not working

[DeniseW]

Every other worksheet my charts auto update, except one. Of course it's one
that changes often... the data on the chart sheet updates, but the chart
doesnt. I checked all the settings and they're right. Frustrating!

 

[Rich O]

I have the same problem. I have a workbook in Excel 2007 (SP1) where three
charts are displayed (automatic calculation selected). Only one of them auto
updates when the source data that it is utilizing changes. The other two
don't auto update. When I look at the source data in the chart, it shows
that it is getting the data through a regular cell reference. Excel does
show the first couple values in the series in parentheses next to the cell
reference, but they are not the right #s -- the series values somehow are not
being updated in the chart when the values change.

Questions -- Why don't they all auto update? (they are created through VBA
code the exact same way) Is Microsoft going to address this issue in the
upcoming Service Pack fix? How do I force a chart to auto update as a
workaround?

If anyone can help me out, I would be very appreciative.