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

G

Guest

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

Steve Rindsberg

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?
Click to expand...

Try changing your security settings in Excel to Low.
 
G

Guest

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
 
S

Steve Rindsberg

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

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

That may *silently* prevent the macros from running.

I don't know that there's any way to kick this in only while links are updating
and not for general Excel use, though. If it were that simple to do, it'd be
equally simple for bad guys to turn the security to low and have their way with
your PCs.
 
G

Guest

Steve Rindsberg said:
Just for grins, try setting security to
SuperMegaHyperDuperGuyWithAK47AtDoorBlockingTheWay or whatever it's called.
Click to expand...

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.
 
S

Steve Rindsberg

Just for grins, try setting security to
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.
Click to expand...

That's the one.
 
S

Steve Rindsberg

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

The problem at root is that PPT will open each XLS file once for each link in the
presentation when it updates.

It's up to Excel at that point to determine whether there are macros in the
presentation and if so, whether they're to be permitted to run (or whether it should
ask the user if it's ok).

You may want to ask about this in one of the Excel groups; perhaps there's a
"trusted" directory where you can store the files so as not to have it bellow at you
all the time.
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting graphs from Excel into PPT 2007 3
In Presentation Mode - want automatic update of links from Excel f 2
Macro security warning with no macros in PPT 2007 - why? 4
Linked Charts in PPT 2007 2
Linking Excel Files to Powerpoint 2
Finding PPT 2002 files that contain macros 1
Edit Links to Files Powerpoint 2007 4
Update OLE links, linking to Excel 7

Top