Breaking automatic links to Excel file before sending to client

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnP - 15 Jun 2006 20:34 GMT

I do a monthly report in Powerpoint that has over a 100 charts and tables
that is linked to excel files. I send the powerpoint file to a client who
then distributes it throughout their company.

I want to use automatic updates for the links but the client will get the
"update links" message when they open it. Is there a way, after I have
finished updating, to create a copy for the client and break the links in one
shot? I don't want to have to break each link one at a time before sending.

Right now I update manually each chart/table.

Thanks,

Reply to this Message

Echo S - 16 Jun 2006 00:13 GMT

Make a copy of the file and go to Edit|Links. You can choose "break links"
there.

Signature

Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com

>I do a monthly report in Powerpoint that has over a 100 charts and tables
> that is linked to excel files. I send the powerpoint file to a client who
[quoted text clipped - 10 lines]
>
> Thanks,

Reply to this Message

Shyam Pillai - 16 Jun 2006 16:35 GMT

If you can program then here is the code:

Break OLE links programmatically
http://skp.mvps.org/ppt00047.htm

Signature

Regards.
Shyam Pillai

Handout Wizard
http://skp.mvps.org/how

>I do a monthly report in Powerpoint that has over a 100 charts and tables
> that is linked to excel files. I send the powerpoint file to a client who
[quoted text clipped - 10 lines]
>
> Thanks,

Reply to this Message

JohnP - 19 Jun 2006 16:56 GMT

Thanks, that worked for tables I have in the file but not the linked charts.
They are still linked. Is there some extra code for this? I did a Paste Link
from an excel table to create the charts in Powerpoint.

Signature

JohnP

> If you can program then here is the code:
>
[quoted text clipped - 15 lines]
> >
> > Thanks,

Reply to this Message

Rate this thread: