Automatic Updation of PPT in Access

[Mahendra1000]

Hello,



Let me be clear on this. I have an excel sheets with tables (Numbers). I have inserted this excel files into PPT. I have a button on my page. I have linked the PPT path to that buttom (using hyperlink).

So, when I click the button the PPT which contains the excel charts is opening (this is good so far)

Changes to be done:

The data in excel sheet is used by many people and they can change it.

When in Access the ppt is opened then it's showing the old data but not the new modified data. (We are right clicking on the ppt table and then updating the links)

We just don't want to do that as we have lot of tables in PPT.

Is there a solution when we open a ppt via access then it should automatically update itself in the backend and should open with the new values.

[Micron]

I'm pretty sure that Power Point will have to be told to get the info rather than have Access control the update as you seem to be suggesting. This can be done as long as your embedded spreadsheet was properly linked to the source file when you put it on the slide. Your ppt will need a macro or code to refresh the data, or you could simply right click on it to and choose "Update Link" to refresh it. A button to run the macro to update the object might be the easiest way to drive the update if you want to go the automated route. However, if you choose to use write code that detects the slide.slideindex property (or whatever else would detect that your spreadsheet slide is the current slide) I suspect it will be more work than what it is worth. I'm afraid I can't help much more than this because I know next to nothing about the Power Point object model.

[Mahendra1000]

Could anyone suggest me the best idea over here