Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    Is there a way to break all links to charts in a Powerpoint presentation? I cannot recall any button similar to the one in Excel in the Edit Links dialog that allows one to "Break" links to all charts in Powerpoint. Is there any advice or code that can do this?

    The powerpoint can be 2003 or 2007. In the presentation will often be several charts that are linked to Excel files. The person recieves these presentations like this, but needs to break the links to the charts and its a waste of time to do this for one chart at a time. There must be a faster way.

    TX
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts
    You can click on the first link, then shift+click on the last one to select all of them in the Edit | Links dialog.
    Then click Break Link:

    [attachment=84689:x.png]
    Attached Images Attached Images
    • File Type: png x.png (5.2 KB, 3 views)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts
    If you prefer a macro solution, see Break OLE links programmatically by Shyam Pillai.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 0 Times in 0 Posts
    TX Hans.

    The Links dialog is (I assume) from PPT2003? I cannot find this dialog in PPT2007. Is this correct.

    TX for the code. I'll test it out.

    Rudi
    Regards,
    Rudi

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts
    The screenshot is from PowerPoint 2003.

    In PowerPoint 2007, click the Office button, select Prepare, then click Edit Links to Files.
    This takes you to the same dialog as Edit | Links... in earlier versions, complete with the Break Link button.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •