un-link Excel files from PP Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rsides - 05 Sep 2006 14:49 GMT

I need to make sure the underlying data for charts in a PPT is NOT avaiable
to viewers to whom I email the presentation. How can I ensure the links to
the Excel spreadsheet, and none of the data itself, is contained in the PPT
file?

Reply to this Message

Steve Rindsberg - 05 Sep 2006 16:17 GMT

> I need to make sure the underlying data for charts in a PPT is NOT avaiable
> to viewers to whom I email the presentation. How can I ensure the links to
> the Excel spreadsheet, and none of the data itself, is contained in the PPT
> file?

Ungroup each chart. That converts it to a picture of a chart and throws away
the data.

I'd be sure you have Fast Saves turned off in Tools, Options, then save the PPT
file under a new name after doing the ungrouping.

You can keep one copy with the charts intact, then do the ungrouping on a copy
that you're going to send out.

A bit tedious to do all that by hand, so you might want to have a look here:

Ungroup all the OLE objects in a presentation
http://www.pptfaq.com/FAQ00326.htm

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message

rsides - 05 Sep 2006 17:39 GMT

> > I need to make sure the underlying data for charts in a PPT is NOT avaiable
> > to viewers to whom I email the presentation. How can I ensure the links to
[quoted text clipped - 22 lines]
>
> Absolutely the correct fix -- thanks. Will also set up the macro you pointed out.

rsides

Reply to this Message

Rate this thread: