Selectively Link Excel Data to a Word Doc

I'd like to link only a section of an Excel spreadsheet to a Word document, but when I select Insert, Object, click the 'Create from File' tab, and choose my Excel file, I get the whole spreadsheet. How do I get just the piece I want, and keep it linked so it updates when I change the original spreadsheet?

Clint Collier, Walnut Creek, California

The trick is not to use Insert, Object. First, open the spreadsheet in Excel, select the range you want to link to the Word document, and press Ctrl-C.

Next, open the Word file that you want to link to the spreadsheet. Position the cursor where you want the range to appear in the document, and then select Edit, Paste Special (you may have to expand the Edit menu to see this option). Choose Paste link (see FIGURE 2). If you don't want the data to update in Word when you change it in Excel, simply select Paste.

Now choose one of the 'As' options. The selection is basically aesthetic. I like the look of the Microsoft Excel Worksheet Object, Picture, and HTML Format options.

• See more like this:
• windows,
• registry,
• startup floppy,
• startup,
• start-up,
• error message,
• error,
• fsinfosector,
• excel,
• word,
• .prn,
• printfile,
• autocorrect.dot,
• mvp