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

C

caliskier

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

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

MrShorty

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.
 
Top