在幻灯片中显示时，PowerPoint中的链接Excel对象不会更新 [英] Linked Excel Object in Powerpoint wont update when showing in slideshow

问题描述

我对此很陌生，基本上我想做的是:

I'm new to this and basically what I want to do is:

-我有2个Excel文件和1个PowerPoint演示文稿 -所有文件都在共享网络中 -我将我的excel文件链接到了powerpoint -我有Office 2003和2007版本

-I have 2 excel files and 1 powerpoint presentation -all of the files are in a shared network -I linked my excel files to the powerpoint -I have office 2003 and 2007 versions

问题:

我播放幻灯片的幻灯片，并将其设置为在1台计算机上循环播放，以在工作中的大LCD上显示它，然后我在另一台计算机上访问excel文件并从那里进行更新，问题是幻灯片正在播放不会自动显示我的更改.我必须手动停止表演，然后单击幻灯片上的(更新链接)以显示我刚刚输入的更新.

I play the slideshow of the powerpoint and set it to loop on 1 computer to display it on a big LCD at work, I then access the excel files on a separate computer and update it from there, the problem is the slideshow that is playing wont display my changes automatically. I have to manually stop the show and click the (update link) on the slides to have it show the updates I just inputted.

有没有一种方法可以使幻灯片在节目中显示我的更新数据，而无需手动停止并单击更新链接.

Is there a way so that the slideshow will display my updated data within the show and I wont have to manually stop it and click the update link.

我在这里找到了一个有点类似的问题，但是并没有得到回答，这将有助于我提出问题.

I have found a somewhat similar question here but it was not answered to the point where it will help me advance my question.

推荐答案

我已经使用此代码解决了上述问题

I've solve the problem above using this code

Sub OnSlideShowPageChange(ByVal SSW As SlideShowWindow)
    If SSW.View.CurrentShowPosition = 2 Then
        ActivePresentation.UpdateLinks
    End If
End Sub

假设我有2张幻灯片，当幻灯片2通过时，它将触发更新链接，并使用更新的OLE链接循环回到幻灯片1.我花了很多时间才能读到这个部分，但是当我开始表演时，我无法运行它.我必须手动按alt + F8并单击运行"，这样代码才能循环播放每张幻灯片2.

Assuming I have 2 slides in the show, when is passes on slide 2 it will trigger the update links and loops back to slide 1 with the updated OLE links. It took me a lot of reading to get to this part but I cant get it to run when I start the show. I have to manually press alt+F8 and click run so the code will loop every slide 2.

终于让它运行而无需运行宏.我只是打开幻灯片并播放节目.当节目通过幻灯片2或刚开始时，更新是动态更新的.现在，仍然有一些解决此问题的方法，希望对您有帮助.

Finally got it working without running the macro once. i just open the powerpoint and play the show. the updates were dynamically updated when the show passed slide 2 or just the beginning. Now there are some that still dont have solutions for this problem, hope this helps you.

我利用了在 http://skp.mvps.org/autoevents.htm上找到的autoevent.zip. .我安装了zip中包含的AutoEvents.ppa作为插件，并在PPT2007和PPT2003中将其激活.然后使用此代码创建一个普通的模块/宏.

I utilized the autoevent.zip found here at http://skp.mvps.org/autoevents.htm. I installed the AutoEvents.ppa included in the zip as an Add In and activated it in PPT2007 and PPT2003. and then created a normal module/macro with this code.

Sub Auto_ShowBegin()
ActivePresentation.UpdateLinks
End Sub
Sub OnSlideShowPageChange(ByVal SSW As SlideShowWindow)
'
' AUTO UPDATE OF OLE LINKS MACRO
'
    If SSW.View.CurrentShowPosition = 2 Then
        ActivePresentation.UpdateLinks
    End If
End Sub

您完成了.请确保在2003和2007中都将您的Powerpoint保存为启用宏的格式，这是因为我有两个版本的ms office.并在勾选框上打勾-信任对VBA项目对象模型的访问.还要循环播放幻灯片，以便当它通过幻灯片2或刚开始放映时，它将更新所有OLE链接.

And your done. Please make sure that you save your powerpoint in macro-enabled format both for 2003 and 2007, this is because I have two versions of ms office. and tick the ckeck box saying -Trust access to the VBA project object model. Also loop your slideshow so that when it passed the slide 2 or just the beginning of the show, it will update all OLE links.

如果我错过了一些事情，请发表评论. 希望这会有所帮助.

Do comment if I have missed something. Hope this helps.

这篇关于在幻灯片中显示时，PowerPoint中的链接Excel对象不会更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！