Preventing "Update Links" dialog in PPT

  • Thread starter Thread starter jaya
  • Start date Start date
J

jaya

I am trying to open a PPT file which is linked to a excel file. I get
this file from the client and i don't get the associated excel file.
When i open the ppt file in VBA, it displays the "Update links"
dialog. How do i prevent it?

I use office 2002...

Thanks.
JayG
 
I am trying to open a PPT file which is linked to a excel file. I get
this file from the client and i don't get the associated excel file.
When i open the ppt file in VBA, it displays the "Update links"
dialog. How do i prevent it?
Click to expand...

Try this:

Select the Excel object in PPT
Choose Edit, Links
Choose the option to update manually
Save the file again

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
I would like to do this VBA and while opening the ppt...
-----Original Message-----
I am trying to open a PPT file which is linked to a excel file. I get
this file from the client and i don't get the associated excel file.
When i open the ppt file in VBA, it displays the "Update links"
dialog. How do i prevent it?
Click to expand...

Try this:

Select the Excel object in PPT
Choose Edit, Links
Choose the option to update manually
Save the file again

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

.
[/QUOTE]
 
I would like to do this VBA and while opening the ppt...
Click to expand...

It might need to be done to the file before opening it.
You can set a linked shape's .LinkFormat AutoUpdate property to
ppUpdateOptionManual I think but by that time, there's already a messagebox
asking what to do about links.

A couple of things you could try as workarounds:

Open the presentation w/o a window
or
Open the presentation, then iterate through open windows looking for the
"Update Now?" dialog and send it keystrokes to close it immediately. Ugly.

Try this:

Select the Excel object in PPT
Choose Edit, Links
Choose the option to update manually
Save the file again

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================

.
Click to expand...
[/QUOTE]

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================
Featured Presenter, PowerPoint Live 2004
October 10-13, San Diego, CA www.PowerPointLive.com
================================================
 
Back
Top