I haven’t tried any of these so I don’t know if they’ll do what you want.Īnother alternative would be to use a macro to update fields and bookmarks on opening or saving the document. The default paste will use the Keep Source Formatting. In the destination Word document, place the cursor where you want the data, then hit CTRL-V. In the source Excel spreadsheet, select the data you want to copy then hit CTRL-C. * File > Options > Advanced panel > General section : Update automatic links at open. The simplest way to display Excel data in a Word document is to use Copy/Paste. * File > Options > Display panel > Printing Options section > Update linked data before printing * File > Options > Display panel > Printing Options section > Update fields before printing In Word 2010 (and likely 2007), try these: There are some Word Options settings that *might* do what you want.
Whenever you change the original text, you only need to update the fields in the document for the changes to apply to the second (or third) instance of that text. You assign a bookmark to the text you want to re-use, then insert a cross-reference to the bookmark text. Of course, it would be nice if you could use a tool designed to deal with this sort of single sourcing (such as Author-it), but you’re stuck with Word. If another author takes over the document, they may not know that they have to update this text in two or more places if there are changes, either. You don’t want to write it twice (or more), and you’d rather not copy/paste it from the other location as that means that you’ll have to remember to maintain it in both places if there are changes. You have some text in a Word document that you’d like to repeat later in that document.