AUTOUPDATE LINKS W/OUT PROMPT

[Sam]

I am creating a presentation that has a large number of linked charts and
graphs from excel. When I open the presentation, it prompts me to update
each linked object individually, which means I have to say "yes" several
dozen times.

Is there a macro or another way to cause it to update without prompting me
to do so - so I dont' have to sit there and hit enter 50 times?

Thanks,
Sam

 

[Sam]

I have looked at the mvp add-ins, but they dont' seem to do what I want them
to. I am still prompted to update each object when I launch the
presentation. I was hoping for something that will keep this from happening.

 

[Sam]

After thinking about it, I think my problem is with excel, not with
Powerpoint. The tables and charts that powerpoint is looking at are
themselves linked to other workbooks and I think it is excel is prompting me
to update each of the sheets.
Is my thinking right? Any ideas how to stop that?
I'll post the question over in the excel forum as well.

Thanks.

 

[Sam]

I figured it out. I just needed to get into excel and tell it not to prompt
for updates.