I am using office 2007. I somehow managed to update links from Excel to powerpoint(.pptx) using macro and autoevents. Links were updating correctly when I go to slideshow from .pptx file. Then I saved the same .pptx file as .ppsm file with macro enabled and closed the .pptx file. Now when I open the saved .ppsm file which is macro enabled, update links only work once. Then I have to click the mouse everytime on slide whenever I require update . The .ppsm file update links automatically works whenever the .pptx file is open. I don't want to open .pptx file. But I need automatic update of Excel links in .ppsm file(macro enabled). Is there any solution to do that?
Update links in PowerPoint slideshow (.ppsm)
-
-
-
Re: Update links in PowerPoint slideshow (.ppsm)
Hello,
You could take a look at following post ...
http://www.ozgrid.com/forum/showthread.php?t=78584&p=663524#post663524
Hope this will help
-
Re: Update links in PowerPoint slideshow (.ppsm)
Thanks for the quick reply. when i run the code it shows data member not found (.ontime).