un-link Excel files from PP Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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 said:
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
================================================


Absolutely the correct fix -- thanks. Will also set up the macro you pointed out.
Click to expand...
rsides
 
Back
Top