How do I link excel to word so excel changes appear in word?
 

I have to write a word document in my submittals and some of what I do
in excel I have to hand type into word. Is there a way I can type
something like "The total cost is $345,897" and have the number change
if my excel pricing changes so I don't have to keep changing the numbers
in the word document?

I know you can paste tables you make in excel into word, but what I
need is to beable to link a cell in excel to the middle of a sentence
in word.


--
caliskier
------------------------------------------------------------------------
caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887
View this thread: http://www.excelforum.com/showthread...hreadid=400815

Here's how I do it:

In Excell, select cell containing desired subtotal
copy
In Word, place cursor in desired location
Edit-Paste Special-Select Link and As Unformatted Text
click OK

Your subtotal (formatted in whatever number format you have applied to
it in Excel), should now be shown in the middle of the sentence. I'm
not sure how Word knows when to update the links, but sometimes I have
to work a few tricks (close and reopen the document, for example) to
make sure Word is using the latest value from Excel, but it should work
well for you.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=400815

Thanks works great


--
caliskier
------------------------------------------------------------------------
caliskier's Profile: http://www.excelforum.com/member.php...o&userid=25887
View this thread: http://www.excelforum.com/showthread...hreadid=400815