Welcome to these tutorials, many of
which were unique concepts when first published!
      
Build: techniques to build faster and more effectively
[ 3d bezier curves ] [ custom toolbars ] [ clever snap to grid ] [ Excel in PowerPoint ] [ fast ppt in outline view ] [ Friday for FAQ's ] [ object selection and visibility ] [ offline clip art (new) ] [ photo albums ] [ powerpoint layouts ] [ round tripping ] [ Save image portion as image in 2003 or 2007 ] [ smart tags ] [ word art from text ] [ xcelsius Interactive Charts ]
Share and Extract Excel Content with PowerPoint
Why?
Gain access to your data that is embedded in PowerPoint.
Often you will have Excel content in PowerPoint, which is a great to
incorporate data in your slideshows. But, how do you extract it back out?
Excel data is entered into PowerPoint via two general methods; either as an
embedded object, or embedded from a file.
For example, an Excel file can be inserted via Insert| Object,
and browse to your file.
Data can be either simply added or linked. Links are great if
your data will change, but you don't ever want to move or lose your source file.
So, this is great. But what if you are presented with such a
file and do not have the source data? well, you can double click the file and
copy the data out, but there is an easier way.
Object Linking and Embedding (OLE) means the Excel file is not
only in your PowerPoint document, but so is the information to run the whole
Excel application. So, by opening the document, we can access the file from
within Excel itself. We right click on the embedded document and select
Worksheet Object| Open.
Now that the data is open in Excel we have a couple of options
available to us. First, we could simply modify the data. Then, when we closed
the file, it would update in PowerPoint.
The other option is to go to the File menu and select Save Copy
As... allowing us to save the contents out as another file. Too easy!
But remember, if it is linked and you lose the source file,
you're sunk.
|
