I don't follow what's going on here, but let me ask this: do you call the OLE
object's Update method before closing the app/releasing the reference to the
object's variable? What you're describing sounds like what happens when you
don't do this.

In article , Hari Prasadh wrote:
Hi,

Im cross-posting/multi-posting this in the hope that I could get a solution.

I am facing a very strange problem (both in Office 2002 and 2003) with Excel
OLE charts in PPT. (Im programming with excel as base)

I am using code zilched from Jon P's site in order to copy data from an
excel sheet and activate a PPT application (and Slide) and an Excel OLE
object within the slide and then updating the data in it and then saving
this template with a NEW NAME.

Im using this method to update a single slide template tons of time and each
time saving it with different (but well-defined) names.

Situation: - The new data gets pasted in the Excel worksheet behind the
chart (within PPT) and then the chart also gets updated and then I do a Save
As (using code) to save it with a new name and in a new location and then
close the file.

I then exit out of the code and then open the file manually and in the slide
show mode can see the UPDATED data but if I try to get in to editing mode of
the Excel OLE chart within PPT then the chart SUDDENLY displays the old data
and the excel worksheet also displays the old data??

If I escape out of the OLE and do Ctrl + Z then it shows the data updated
through Macro.

Couple of my colleagues were running tests and they see that if they save
the file manually after updating data through Macro then the same problem
doesnt recur? Im not very sure why it is so and nor Do I know whether the
above observation about manual saving is correct for all situations.

For me manual saving is not an option.

We are also experiencing the same problem in updating excel worksheets
within PPT's.

Can anybody please guide me as to what is happening here?

Regards,
Hari
India


-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================