Q&A

Q1:When I copied and pasted data from an Excel worksheet into a Word document, and then made changes to the worksheet in Excel, why didn't the worksheet in Word change to reflect the new data?
A1: Instead of copying and pasting, you need to link the Excel worksheet to the Word document in order to update the worksheet automatically. To do so, select the Edit, Paste Special command and the Paste Link option in the Paste Special dialog box. In the As list box, make sure that Microsoft Excel Worksheet Object is selected.
Q2:After embedding an Excel worksheet in Word and changing data in the worksheet, why do the Excel toolbars instead of the Word toolbars display onscreen?
A2: Click outside the worksheet area to display the Word toolbars.
Q3: ...

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.