+ Reply to Thread
Results 1 to 4 of 4

Embedded Excel document in Microsoft Word

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Poland
    MS-Off Ver
    Excel 2003
    Posts
    8

    Lightbulb Embedded Excel document in Microsoft Word

    Hello!

    I have one very hard to solve problem for me so if anybody will be able to help me I will be very grateful!

    I have an Word document where I need to place many different embedded excel objects. The only problem is, that there must be some of relationship between them (ex. make sum in table A based on data from table B or make average in table C from data in table B etc.) The problem is that they are (embedded objects) independent and do not want to work together...

    I figured that maybe I could create one embedded excel and show different parts of it in different places of Word document. What do you think? If this even possible?

    Maybe do you have better idea that mine?

    I'm using Microsoft Office 2003 (this is company software) and everybody have the same, so I'm searching the solution for software not higher than 2003...

    I will be really appreciated when somebody will help me or have better idea that mine!

    Thank you and have a nice day!

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,641

    Re: Embedded Excel document in Microsoft Word

    The simplest solution is to use an external workbook and copy/paste the required ranges into Word using the Paste Special 'Paste Link' option. That way, you don't need the Word document to be open to edit the data but, when you do, all the links will update to reflect the latest data.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    11-21-2012
    Location
    Poland
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Embedded Excel document in Microsoft Word

    Quote Originally Posted by macropod View Post
    The simplest solution is to use an external workbook and copy/paste the required ranges into Word using the Paste Special 'Paste Link' option. That way, you don't need the Word document to be open to edit the data but, when you do, all the links will update to reflect the latest data.
    Hello marcopod,

    This is great! There is no possibility to do the same but embed excel inside word?

    I'm trying to find solution for many users, different database's etc. so the less external files - that's better.

    But overall - this is the effect that I wanted to achieve!

    Thanks!

  4. #4
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,641

    Re: Embedded Excel document in Microsoft Word

    The external workbook approach probably wouldn't suffice for many users with different requirements, as you'd need to set up a new one for each use (eg by copying the workbook to a new location or giving the copy a new name), then updating the link references in Word to point to the new workbook. Is there a reason it has to be a series of embedded Excel workbooks (eg cannot Word tables suffice)?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1