What is the easiest way to do calculations in a word document with excel as a link?

[Jeff Globerman]

I am trying to complete a word legal form that has calculations included.
I can add numbers but can't subtract or add between different tables.
What is the easiest way to link excel and the word documents together?

 

[bobhc]

Good day and welcome to the forum if you have not already done so, please read this link posted by Chandoo as it will help you in the use of the forum.

http://chandoo.org/forum/threads/new-users-please-read.294/

As to your question you could make your working table in excel and inbed it in word, this way any updates to the excel file will auto update the word file.


.

 

[Jeff Globerman]

Thank you. Can you tell me the steps to do this?

 

[bobhc]

This link will show you various methods (I am not into rewriting the book ) but you can totally ignore the first method, copy paste, it does not auto update.


.

 

[Jeff Globerman]

Thanks but there was no link?

 

[Smallman]

Hi

If I have to link word and excel I use the paste link function provided by Word. Copy your Excel table, Open Word - On the Home tab - click the Paste drop down arrow. Paste Special

See the link attached.

As the data in your Excel sheet changes the word document changes in line with the changes.

Take care

Smallman

 

[bobhc]

Sorry heads a shed at the moment (empty shed at that)

http://www.techrepublic.com/blog/ho...el-information-and-objects-in-word-documents/


.

 

[Jeff Globerman]

Thanks to everyone for their help