Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel OLE data in PPT reverting to OLD data after macro updation
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
pasting excel data in a powerpoint slide | Excel Discussion (Misc queries) | |||
How do I plot Excel data on a floorplan? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |