Table of all methods of copying data from Excel to ...

Table of all methods of copying data from Excel to PowerPoint (Windows versions)

Cells, Tables and Named Ranges

Step 1 in Excel

Step 2 in PowerPoint

Copy Cells Copy Cells

Paste (Use Destination Styles) Paste (Keep Source Formatting) Paste Special ? HTML Paste (Embed)

Copy Cells

Copy Cells Copy Cells Copy Cells Copy Cells Copy Cells

Paste Special ? Excel Worksheet Object Paste (Picture) Paste Special ? Picture (Enhanced Metafile), Picture (Windows Metafile), Device Independent Bitmap, or Bitmap Paste (Text Only) Paste Special ? Formatted Text (RTF) or Unformatted Text Paste Special ? Paste Link ? Excel Worksheet Object Paste Special ? Paste Link ? Excel Worksheet Object ? Display as Icon Paste Special ? Paste Link ? Attach Hyperlink

Object on slide

PowerPoint Table with PowerPoint Theme formatting

Edit object in PowerPoint? Formatting in PowerPoint?

Yes

Yes

PowerPoint Table with Excel formatting

Yes

Yes

Embedded Excel worksheet

Double click to edit in Excel

overlay in PowerPoint

Yes

Picture

No

No

Text pasted into selected PowerPoint Object

(i.e. Smart Art) or (if pasted directly on slide)

PowerPoint Text Box

Yes

Yes

Double click to open linked

Drawing Object linked to Excel worksheet file Excel worksheet

No

Double click to open linked

Excel Icon hyperlinked to Excel worksheet file Excel worksheet

No

Text from first cell hyperlinked to Excel

Double click to open linked

worksheet file

Excel worksheet

No

Paste (use Destination Theme and Embed Chart object with PowerPoint Theme

Copy Chart Workbook)

formatting

Yes

Yes

Paste (Keep Source Formatting and Embed

Copy Chart Workbook)

Chart object with Excel formatting

Yes

Yes

Resizing in PowerPoint

Animation in PowerPoint

Method of data update

Updates if new columns or Access to full

rows added?

Excel source file

Access to edit data if Excel source file not available

All directions

On or off

Manually in PowerPoint

Manually in PowerPoint No

Yes

All directions

On or off

Manually in PowerPoint

Manually in PowerPoint No

Yes

Non-proportional resizing On or off, includes Manually in Excel object on PowerPoint Manually in Excel object on

stretches text

OLE Action Verbs slide

PowerPoint slide

No

Yes

All directions

On or off

Recopy ? Paste from Excel

Recopy ? Paste from Excel No

No

All directions

On, off, by row

Manually in PowerPoint

Manually in PowerPoint No

Yes

Non-proportional resizing On or off, includes Click Update data button in dialog box

stretches text

OLE Action Verbs when PowerPoint file opens

Only if Named Range

Yes

No

On or off, includes Click Update data button in dialog box

All directions

OLE Action Verbs when PowerPoint file opens

Yes, on the Excel worksheet Yes

No

Click Update data button in dialog box

All directions

On or off

when PowerPoint file opens

Yes, on the Excel worksheet Yes

No

Manually in PowerPoint

All Chart animation Click Edit Data button on Chart Tools ?

All directions

options

Design ribbon

Manually in PowerPoint No

Yes

Manually in PowerPoint

All Chart animation Click Edit Data button on Chart Tools ?

All directions

options

Design ribbon

Manually in PowerPoint No

Yes

Paste (use Destination Theme and Link Chart object with PowerPoint Theme

Copy Chart Workbook)

formatting linked to Excel worksheet file

Yes

Yes

Paste (Keep Source Formatting and Link Chart object with Excel formatting linked to

Copy Chart Workbook)

Excel worksheet file

Yes

Yes

Paste (Picture)

Proportionally from corner All Chart animation Click Update data button in dialog box

only

options

when PowerPoint file opens

Yes

Proportionally from corner All Chart animation Click Update data button in dialog box

only

options

when PowerPoint file opens

Yes

Yes

No

Yes

No

Copy Chart Copy Chart

Paste Special ? Picture (PNG), Picture (Enhanced Metafile), Picture (JPEG), Picture (GIF), Picture (Windows Metafile), Device Independent Bitmap or Bitmap Paste Special - Microsoft Office Graphic Object (2007 & 2010)

Image Chart object linked to Excel worksheet file

Paste Special ? Excel Chart Object (2013

Copy Chart Only)

Drawing object

No

No

No

Yes

Double click to open embedded Excel worksheet No

All directions

On or off

Recopy ? Paste from Excel

Recopy ? Paste from Excel No

No

All Chart animation Click Refresh Data button on Chart Tools -

All directions

options

Design ribbon

Yes

Yes

No

Manually in PowerPoint

Proportionally from corner On or off, includes Click Edit Data button on Chart Tools ?

only

OLE Action Verbs Design ribbon

Manually in PowerPoint No

Yes

Charts

Paste Special ? Paste ? Excel Worksheet Excel Icon hyperlinked to embedded Excel Double click to open

Copy Cells Object ? Display as Icon

worksheet

embedded Excel worksheet No

Copy Chart Copy Chart Copy Cells

Paste Special ? Microsoft Office Graph Object Paste Special ? Paste Link ? Excel Worksheet (2007 & 2010)/Chart (2013) Object Paste Special ? Paste Link ? Excel Worksheet (2007 & 2010)/Chart (2013) Object ? Display as Icon

Microsoft Office Graph object (2003 & earlier) Yes

No

Double click to open linked

Drawing object linked to Excel worksheet file Excel worksheet

No

Double click to open linked

Excel Icon hyperlinked to Excel worksheet file Excel worksheet

No

Insert Chart ? Paste Special ? Paste Values

Copy Cells to Chart data table

PowerPoint Chart with unlinked data

Yes

Yes

Insert Chart ? Formula link from Chart data PowerPoint Chart with data linked to Excel

table to cells in Excel worksheet

worksheet cells

Yes

Yes

On or off, includes Manually in PowerPoint (opens

All directions

OLE Action Verbs embedded worksheet in Excel)

Yes, on the Excel worksheet Yes

No

Manually in PowerPoint

Proportionally from corner

Click Edit Data button on Chart Tools ?

only

On or off

Design ribbon

Manually in PowerPoint No

Yes

Proportionally from corner On or off, includes Click Update data button in dialog box

only

OLE Action Verbs when PowerPoint file opens

Yes

Yes

No

All directions All directions All directions

On or off, includes Click Update data button in dialog box

OLE Action Verbs when PowerPoint file opens

Yes, on the Excel worksheet Yes

No

Manually in PowerPoint

All Chart animation Click Edit Data button on Chart Tools ?

options

Design ribbon

Manually in PowerPoint No

Yes

Manually in PowerPoint

All Chart animation Click Edit Data button on Chart Tools ?

options

Design ribbon

Manually in PowerPoint No

Yes

?2014 Dave Paradi. All rights reserved. Do not copy or distribute without permission. Special thanks to Glenna Shaw of for her assistance in preparing this table.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download