Ok heres the problem. I have been given several Word documents and excel files. In the Word documents there are tables(I can't change any of the formatting). I need to create links between the fields in the tables to various fields in the spreadsheet. I would normally use the "Paste Special" way but I have about 80 tables that I have to link. Is there any way that I can link many fields in the word tables to an equal amount of cells in the spreadsheets.the formatting between them is the same. There are blocks of data together that I can use. Any ideas would be really appreciated. Thanx
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linked cells in word
- Thread starter Philly44
- Start date
Generally, you select your data in Excel, copy it, go to Word and hit Edit-Paste special-Paste link. You format the data in Excel, not Word, when you do it this way. If you can't format the native data in Excel because it's used for other purposes in a different format, then make yourself a "tweener" file. Copy all the cells from Excel, open a workbook and Edit-Paste special-Paste links. Save it, format the way you want it in Word, and the link Word to THIS file.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
- Status
Similar threads
- Locked
- Question
- Locked
- Question
