O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required