PPT link to Excel files/graphs -- update with disabling macros

[Mike]

I have seen many good notes in the discussion group on PPT links to Excel,
but am having trouble with the following.

I have one PPT with about 25 links to Excel files/graphs, each with their
own macros. When I update the links, each file is asking me to "Enable or
Disable" the macros. I have to do this 25 times. :-(

Is there an easy way to make a setting or macro to force an update and
automatically disable the macros?

 

[Mike]

Thanks for the recommendation. Unfortunately, lowering the security would
_enable_ the macros. Is there a method to _disable_ the macros while updating
the links?

Thanks!
Mike

 

[Mike]

Just for grins, try setting security to
SuperMegaHyperDuperGuyWithAK47AtDoorBlockingTheWay or whatever it's called.

Do you have any advice where to make the change? All I know to change is
"Very High" all the way to "Low", which has to be done in Excel.

 

[Mike]

Thanks. This works in LOW, but I am back in square 1. :-(

 

[aneasiertomorrow]

"trusted" directory where you can store the files so as not to have it
bellow at you
all the time.

Just a thought, but could you use self-signed certificates & trust yourself?
For more info see here:
http://office.microsoft.com/trainin...ID=RC011615881033&CTT=6&Origin=RC011615881033

Lucy
www.aneasiertomorrow.com.au

 

[aneasiertomorrow]

<curtsey> glad to be of assistance

Lucy
--
MOS Master Instructor
www.aneasiertomorrow.com.au

PowerPoint Live 2007 28-31 October in New Orleans www.pptlive.com
See you there

 

[avi]

Dear Mike,

Following your interst in Excel to PowerPoint export, I am glad to
announce the release of EzPaste-xl2ppt, a software aimed at
completely automating the task while providing maximum flexibility.
The product could improve drastically productivity

For more details please consult http://www.EzPaste.net

Comments and suggestions will be welcomed

Thanks for your attention

Avi
Metrics institute