MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I insert an excel link in a word document?

Posted by Kevin Skinner on October 26, 2001 7:00 AM

Is there any way to insert a link to a specific cell from an excel file into a specific location in a paragraph of a word document, so that when you change the number in excel, the number referred to in word is updated as well? i know this is kind of a Word question, but I would appreciate any help at all, as this is work-related

Posted by lenze on October 26, 2001 7:25 AM

The easiest way is to copy the cell and do a Paste Special in your Word document, choosing the link option.

Posted by kevin skinner on October 26, 2001 7:34 AM

The only problem is I need the number that is pulled from excel to look like it is just type in along with all of the other words as part of the sentence. I tried pasting as a link and it inserts what looks like a spreadsheet cell into the word document. Also, it does not put it in the right place.


Posted by kevin on October 26, 2001 8:01 AM

additional followup

Specifically, this is what I am trying to do: I have a word document that contains sentences similar to this:

"There was an increase in total operating revenues for the nine-month period ended September 30, 2001, when compared to the same period in 2000, of $100,000, or 2.5%."

What I would like is for the $100,000 and the 2.5% numbers to automatically update themselves based on the data in the spreadsheet, but for presentation purposes they need to look like they do above, like they are part of the sentence typed in word, and I don't want it to look like an excel link.


Posted by lenze on October 26, 2001 8:06 AM

When you do the Paste Special, make sure you choose the "Formatted Text(RTF)" option.

Posted by Kevin Skinner on October 26, 2001 8:17 AM

thank you

it works now - much appreciated