All,

I use ADO to modify data in Excel, when I open the excel file, the data in
is showed updated, but when I use another program to visit it, the data is
not updated.
When I open and then close the file manually, the excel prompt me to save.
if I choose save, the data got by another program is right, if not save, the
data is still keep the original value.

Can someone give me the suggestion on how to avoid this issue.
Some demo code will be highly appreciated,

thanks,

Albert