Discussion Locked

Copying Excel Charts/Tables Into Word

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Our monthly reports are produced in MSWord but most of its contents are Excel charts and portions of spreadsheets that we copy, then paste into the Word report template. We are finding the copy/paste method is taking us a lot of time and may not be the most efficient way of doing this. Can anyone suggest a better, faster way of doing this?

1 reply

by stevecottle

One good way of doing this is to paste a link to your spreadsheet rather than pasting a copy of the data. Here's what you do.

Create a new spreadsheet. Fill in four cells with the numbers 1, 2, 3, and 4. Save the spreadsheet with the name Workbook.xls.

Now create a new document. Mark the four cells in Workbook.xls and select Copy (Ctrl+C). In your Word document, select Edit, Paste Special. Click the radio button for Paste link. You can pick any of the formats listed. If you are used to cutting and pasting from a spreadsheet, you probably want Formatted Text. Click OK. Now your document and spreadsheet are connected. Any time you update the workbook and then load the document, the content of the document will change.

To keep historical versions of your reports, you may want to disconnect the link and save the document to a different name. To disconnect the link, select the linked area and press Ctrl+Shift+F9.

I would probably choose to put the linked data into the template so each time you use the template, the data will be pre-loaded from the spreadsheet.

This discussion is closed to new replies.