excel worksheet

Fri
21
Jul
Dennis Faas's picture

Embed Excel Worksheets in a Table: MS Word

Rather than just pasting raw numbers into a table, you can embed a worksheet into a document. Embedding retains the formulas that ride behind your numbers and all the functionality of Excel. You can create an Excel worksheet from scratch, or, if the ... worksheet already exists, you can insert it using the Paste Special command. Although an embedded worksheet behaves as a picture in the document, when you double-click to modify it, Excel opens within MS Word, allowing you to use Excel's formulas to calculate results. One drawback to embedding an Excel worksheet is that it increases the file size ... (view more)

Fri
14
Jul
Dennis Faas's picture

Link Excel Worksheets: MS Word

The Paste Special command can also be used to link an Excel worksheet. In contract to embedding, linking sets up a link between the worksheet cells in the document and the original Excel worksheet source. The MS Word document holds an image of the ... Excel worksheet and a shortcut to it but not an actual copy of the worksheet. Because of the link, any changes in the original are automatically reflected in the MS Word document. The advantage to linking the worksheet is that if the source worksheet in Excel changes, the values are automatically updated in the Word document. If you make a change in ... (view more)

Wed
12
Jul
Dennis Faas's picture

Link Excel Data as a Table: MS Word

Another method for linking Excel places the worksheet cells in a Word table. To do this, you insert the Excel selection as HTML (the universal text format used on the Web). Linking Excel data as a table offers two advantages: You format it using the ... familiar techniques you use with any Word table. Of course, you wouldn't want to change the numbers (although you could). Changes you make in the table do not affect the Excel workbook though. The information is lined so that it automatically reflects any changes made in the original Excel worksheet. Links are automatically updated when you open ... (view more)

Subscribe to RSS - excel worksheet