Update links in PowerPoint slideshow (.ppsm)

  • 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?