Results 1 to 3 of 3

Thread: Linking two worksheets in word
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2004
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Linking two worksheets in word

    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!

  2. #2
    Board Regular sergioMabres's Avatar
    Join Date
    Feb 2013
    Location
    Córdoba, Argentina
    Posts
    946
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Linking two worksheets in word

    This link may help you:
    https://www.cnet.com/news/your-optio...-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

  3. #3
    Board Regular
    Join Date
    Oct 2004
    Posts
    99
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Linking two worksheets in word

    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!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •