Linking two worksheets in word

imback2nite

Board Regular
Joined
Oct 30, 2004
Messages
101
This is probably an easy one but, I have two excel 2003 worksheets in a single Microsoft Word doc.. Is there a way I can link them? Or at least a sum on one page to another?
What I have is a long spreadsheet that I wish I could fit on one sheet but it is way to long. I had to put the information in two sheets. What I would like to do is as add the sum on page one and add it to page two for a final sum. For instance one page one of the word doc I have a sum.
=SUM(E2:E6)
On page two of the word doc I have
=SUM(E2:E13)
Can I name the ranges in either of the worksheets to reference them in a formula or...I don't know. Thank you so much for any help!
 

sergioMabres

Well-known Member
Joined
Feb 24, 2013
Messages
946
This link may help you:
https://www.cnet.com/news/your-options-for-placing-excel-data-in-word/

Copy the worksheet data as described above, and then click inside the target Word document where you want the worksheet to appear. Choose Edit > Paste Special in Word 2003, or click Paste > Paste Special under the Home tab in Word 2007. In both versions, click the Paste link button, choose Microsoft Office Excel Worksheet Object, and click OK. Whenever you change the worksheet in Excel, you can have the modifications added to the Word version by selecting the worksheet in the Word document (after you've saved the Excel version), and pressing F9.

Cheers
Sergio
 

imback2nite

Board Regular
Joined
Oct 30, 2004
Messages
101
Thank you! I did do some research and the way your suggesting is the best way to accomplish what I'm trying to do. Unfortunately the document won't stay on my computer. From what I understand when the Word doc is moved, the link is terminated. I guess what I'll have to do is recreate the whole document in Excel. I actually think it will be easier that way. As they say, Word was invented for the few things Excel can't do. I just haven't discovered what they are! Thank you for answering!
 

Forum statistics

Threads
1,085,089
Messages
5,381,649
Members
401,747
Latest member
Jtvan

Some videos you may like

This Week's Hot Topics

Top