Update excel links automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spidey - 15 Nov 2006 23:57 GMT

Hi all! I have successfull made a ppt presentation with many many linked
excel charts and lists (all of which reside in the same workbook). The excel
file, however, is links to multiple other excel files. All of the
linksupdates fine.

When I open the ppt file before the excel file, I get the following question
for every separate excel link i have in the ppt file...

"THis workbook contains links to other data sources.

-To update all linked information, Click Yes.
-To keep the existing information, click no."

Is there any way to open the PPT file 1st without getting a million update
messages?

Reply to this Message

Echo S - 16 Nov 2006 20:01 GMT

Look in Edit|Links and see if you can set the links to update manually.

Signature

Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

> Hi all! I have successfull made a ppt presentation with many many linked
> excel charts and lists (all of which reside in the same workbook). The
[quoted text clipped - 13 lines]
> Is there any way to open the PPT file 1st without getting a million update
> messages?

Reply to this Message