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:
What can I do to correct embedding the wrong worksheet from the workbook in my Word document?
A3:
When you embed a worksheet object, the entire workbook is inserted. To display the correct worksheet in Word, double-click the worksheet in the Word document, click the sheet tab you want, and then click outside of the worksheet area in Word.
Q4:
When I tried sending my workbook in an email message via Outlook directly from Excel, why didn't the recipient receive my message?
A4:
Be sure that you're connected and online with Microsoft Exchange or a network. Then try sending the mail again.
Q5:
I cannot find the E-mail button on the Standard toolbar.
A5:
Make sure that Microsoft Outlook is installed on your computer. If it isn't, the E-mail button does not appear on the Standard toolbar.
