Excel chart not updating after the underlying data range changes

Hi,

I was not having this issue until recently. I have a chart which depends on a data range. This data range gets data from a webquery. When I click on 'refresh all', the data is updating; but the chart is not updating until I save the file. I was not having this issue earlier. It used to update the chart without saving the file. Can you please help? Attached the excel file.

NB:I am using excel 2007. Attached the version info also.

Is your calculation set to manual? - try hitting F9

Thanks for the reply.
No. It's automatic. I have attached the excel.

You might have "Attached the Excel" but my excel is set up for automatic calculations regardless of workbook so your workbook works fine.

Did pressing f9 after changing the data update the graph?

Yes it does. Even if I save the excel using Ctrl+S; it reflects the updated data in the chart. But earlier I didn't have to save or press F9 to update the data. Can you pls tell me if some latest excel update might have introduced this?

I suspected so and uninstalled the last update from my system but still the issue exists.

You need to change your calculation to automatic, I suspect something you may have inadvertently done has set it to manual

My calculation mode is already set to automatic. Ruling out the and inadvertent thing as few other people are also having the same issue with the excel.