Powerpoint Updating Links

[hitchy79]

Can anybody help, I want to update my linked slide automatically for
which the Update Links add-in helps

http://www.mvps.org/skp/updtlinks.htm

however as my excel workbook has macros, every time the slideshow
loops, I am confronted with the "enable macros?" dialog box, which
naturally makes my presentation manual rather than automatic. Is there
a way around this? PS setting macro security to low does not work!

Thanks
Tom

 

[Steve Rindsberg]

Can anybody help, I want to update my linked slide automatically for
which the Update Links add-in helps

http://www.mvps.org/skp/updtlinks.htm

however as my excel workbook has macros, every time the slideshow
loops, I am confronted with the "enable macros?" dialog box, which
naturally makes my presentation manual rather than automatic. Is there
a way around this? PS setting macro security to low does not work!

Have you set it to low in Excel? That's where the message is coming from.

 

[hitchy79]

Hi, have tried to set macro security to low however believe network
admin will not allow this which is why Excel reverts back to security -
medium level. Is there another way to work around this issue? Seems
that when you link from Powerpoint to Excel The linked worksheet is
actually being held open by Excel which in turn prevents changes being
made to workbook on another machine..
Thanks for your help
Tom

 

[hitchy79]

Fixed: just link all values to a new workbook and set update links to
automatic in Tools tab, then the macro dialog box doesn't have a reason
to pop up!
You gotta love the workarounds
Tom

 

[Steve Rindsberg]

Fixed: just link all values to a new workbook and set update links to
automatic in Tools tab, then the macro dialog box doesn't have a reason
to pop up!

So the idea is something like this?

PPT with Excel content that links to ...

XLS A with data (but no macros) that links to ...

XLS B (that also has macros)

 

[hitchy79]

that's it, simple really once you verbalise the issues you have!!
cheers