oit_content_123203 - Pasting Excel Charts in Word or...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Pasting Excel Charts in Word or PowerPoint Goal Paste chart with a link to the original Excel workbook (default option) Advantages/Disadvantages Small file size Can update data but must have access to the original Excel file Can format using source or destination theme Small file size Can't update data Theme of chart changes as Word or PowerPoint theme changes Results in a larger file size The Excel chart can be edited. However, there is no connection to the original workbook. The chart is embedded in Word or PowerPoint but uses Excel to make changes. CAUTION: Because the entire workbook is inserted along with the chart, all worksheets can be viewed. Reflects destination theme by default File size largest yet Can't update data Format will always be the source file's format despite the paste option for "Use Destination Theme" Can format using Word's numerous picture formats Action in Excel Copy Chart Action In Word or PowerPoint Paste Paste Options Menu Not used Paste chart and break the link to the original Excel workbook Embed entire chart workbook Copy Chart Paste Then: Office Button > Prepare > Edit Links to Files > Break Link Paste Then: Paste Options button: Excel Chart (entire workbook) Not used Copy Chart Paste chart as a static picture Copy Chart Paste Then: Paste Options button: Paste as Picture 2008 by University Technology Training Center University of Minnesota, Minneapolis, MN 55455 Duplication of material without prior written consent is forbidden 05.01.08 Pasting Excel Worksheet Data in Word Goal Paste data as a table (default option) Advantages/Disadvantages Small file size Data is not linked to Excel so does not update automatically Can change numeric data in the Word table but formulas do not update. Action in Excel Copy Worksheet Data Action In Word Paste Paste Options Menu Not used Paste data as a table with a link to Excel workbook Copy Small file size Data is linked to Excel and can be updated as Worksheet Data can formats. CAUTION: can edit data directly in Word but formulas are not updated we do not recommend this! Formatting with Word Table Styles overrides Excel formatting Results in a larger file size The Excel object can be edited; there isn't any connection to the original workbook. CAUTION: Because the entire workbook is inserted along with the chart, all worksheets can be viewed. Format in Excel Copy Worksheet Data Paste: Paste Options button: Keep Source Formatting and Link to Excel or Match Destination Table Style and Link to Excel None Paste entire workbook as an embedded Excel object Paste Special > Paste > MS Office Excel Worksheet Object Pasting Excel Worksheet Data in PowerPoint Paste data as a table (default option) Small file size Data is not linked to Excel so does not update automatically Can change numeric data in the PowerPoint table but formulas do not update. Small files Can update data but must have access to the original Excel file Can only format in original Excel file Copy Worksheet Data First: Select a placeholder by clicking on the placeholder border Then: Paste None Paste data as an object with a link to Excel workbook Copy Worksheet Data Paste Special: Paste link > Microsoft Office Worksheet Object None ...
View Full Document

Ask a homework question - tutors are online