Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Henry
 
Posts: n/a
Default Reference Excel data in a Word document

I have about 80 separate Word documents each containing one field that
occasionally needs to be updated. As opposed to opening each one to change
the fields, is there a way to create an Excel file with all the updates and
have the Word document reference the Excel file to automatically update when
changes are made?
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
brandie
 
Posts: n/a
Default Reference Excel data in a Word document

Henry,

If you have set up the Excel file with the appropriate information, copy the
cell containing the information in Excel, place your cursor in the Word
document where you need the information, and click Edit Paste Special
Paste Link. It will update the document when you open it.

Brandie

"Henry" wrote:

I have about 80 separate Word documents each containing one field that
occasionally needs to be updated. As opposed to opening each one to change
the fields, is there a way to create an Excel file with all the updates and
have the Word document reference the Excel file to automatically update when
changes are made?

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
how do i set up template in vbeditor without proggramming language ARRRGH New Users 4 October 1st 05 03:19 AM
How do I consolidate multiple mail merge data files into one file Robert Mailmerge 6 July 7th 05 10:11 PM
Macros - Keyboard Commands Janet Microsoft Word Help 6 April 11th 05 05:28 AM
Continuous breaks convert to next page breaks Jennifer Hunt Microsoft Word Help 2 December 30th 04 05:45 PM


All times are GMT +1. The time now is 11:52 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"