Although sharing work between Word and Excel often works well, differences in how the two programs operate can produce confusing results. You can address this issue by becoming aware of those differences and working to accommodate them. This section looks at Word and Excel and ways to share text, data, tables, and graphics.
Word offers a variety of different ways to share and exchange content with Excel:
Clipboard: Copy content to the Clipboard and then use Paste or Paste Special to insert the contents into Word or Excel. Commandment: When in doubt, use Paste Special.
Chart: Use Office 2007’s new Chart feature to create a chart inside Word using Excel’s facilities.
Object: Use Insert Text Object Object Create New or Create from File to embed all or part of an Excel worksheet into a Word document.
File: Use Insert Text Object Text from File to insert content ...