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.
Trending Software posts
Sort by Trending