Linking an Excel cell to section of a Word Document

**CharlesEric** · 08-12-2009, 02:46 PM

Hello guys.

I have no idea if this can be done. But since you guys are the best of the best, I'm asking about it

I have Word documents for contribution submissions that are divided into different aspects (1. Summary, 2. Eligible Recipients, 3. Application Requirements, and so on...). Now, I used Excel to make a database based on those documents, which means that for each contribution submission there is an Excel column for summary, one for eligible recipients, for application requirements, and so on. So one column for each section of the Word document.

Now, what I want to do is somehow link the Excel database with the Word documents. which would allow me to make changes in the Excel database/Word document that would be automatically made in the corresponding Excel column/Word section.

I hope you guys understand. I have absolutely no idea how to do this.

**oldchippy** · 08-12-2009, 06:14 PM

Hi,

Does this link help?

http://word.tips.net/Pages/T000056_E...Worksheet.html

**CharlesEric** · 08-14-2009, 01:32 PM

Hey, thanks very much for replying, I didn't think anyone would understand what I was trying to say.

What I'm trying to accomplish definitely looks like what was explained in the link you posted. Unfortunately, I just wish there could be a way to do it the other way around. Instead of imbedding an excel worksheet, imbedding a word section of a document. I want to make some changes to my database so that the changes are also automatically made in the Word document. I'll send you the database in a zipfile so that you can take a look if you want. Each cell/column is corresponding to a section of a word document.

I don't think there is a way to do this, but giving that I know almost nothing about Excel compared to you guys, it's worth a try.

**oldchippy** · 08-14-2009, 02:30 PM

Hi,

I'm not the best one to ask on this because it's something I can't say I've done myself, but searching around it looks like it's always the Excel gets embedded in the Word document.

Here's some more information explaining the difference with Embedded Objects and Linked Objects

http://office.microsoft.com/en-us/ex...984241033.aspx

**CharlesEric** · 08-14-2009, 02:53 PM

Ok, so this means what I actually want to do is to use linked objects.

For example, if you select a range of cells in an Excel workbook and then paste the cells as a linked object in a Word document, the information is updated in Word if you change the information in your workbook.

That is exactly what I want to do. But I do not want the link to be like a pasted OBJECT in Word, well maybe an object, but that does not look like an Excel cell, that would just be like a paragraph of text. A wrapped paragraph of text, just like a text box, where I can change the font and everything, and make the background white, so it looks as if it is just a Word document.

What you have posted is very helpful and enlightening, and I thank you a lot for that. I'll try linking and see if I can do with it.