He he. Read back aways, and you'll see that Hari abandoned my simpler
suggestion to update the charts in Excel and then put them into Ppt. He
prefers doing it the hard way....

Hari's trying to update Excel charts in Excel workbook OLE objects which
are embedded in PowerPoint. I've been strangely silent on this topic.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Brian Reilly, MS MVP wrote:

Hari,
First mistake is using any of Jon P's instructions. (VBG) Jon is a
good friend and a well respected MVP. But that doesn't stop us from
teasing him (g).

As Steve said we aren't sure what you are doing here (exactly by code)
so can you post the relevant parts.

Then we can let Jon Peltier answer his own mess (vbg). Couldn't resist
Jon, Hari is a recent regular in the PPT NG.

Hari, Jon is a regular stop in in the PPT NewsGroup and works
regularly in Excel and PPT integration all the time.

Brian Reilly, MVP

On Tue, 2 Aug 2005 01:18:42 +0530, "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