Problem updating an embedded excel spreadsheet

Hi,

I have a word 2007 document with a Excel 2007 spreadsheet embedded within.

I'm able to get the spreadsheet part and update some values and save it back but, when I open the document in word still shows the old values since is using the old EMF image to represent the OLE Object.

How can I tell word to refresh that EMF image everytime the user opens the word doc ???

Is there any other approach to solve this problem ???

Thanks in advance.

Basically if you modify the chart data, you need to modify the chart.xml as well so that preview image of the chart should be generated correctly.

The following article explains as how to do it
http://msdn.microsoft.com/en-us/library/dd452407.aspx

Look for the section "Adjusting the Chart Data"

Regards,
Ankush