Results 1 to 3 of 3
  1. #1
    eaolsen5
    Guest

    Multiple Excell Items in One Word Doc (2000)

    I am working on a Technical Document in Word.
    I have several tables and charts in a single Excel file that need to be inserted various places in the Word Document. I would like all of the imported items in the Word Dorument to remain linked to the Excel file. I have no trouble getting the first item imported and linked, but when I add the second item, the first link changes to look identical to the second. Then anytime I do something in the Excel file, all of the links change to the Excel sheet I was last on.

    Any help you could offer would be appreciated!!

    Erik

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multiple Excell Items in One Word Doc (2000)

    Well, I can only tell you what I would do. Make each link a separate file in Excel.

    If you need to, you can link the main Excel file to those separate files, so the separate files get changed (hence, the Word doc gets updated) when the main Excel file gets changed.

  3. #3
    eaolsen5
    Guest

    Re: Multiple Excell Items in One Word Doc (2000)

    I figured out how to do it. Instead of using "Insert Item" you use "Copy - Paste Special" and choose "Link to File". I hope this helps someone out there.

    Erik

Posting Permissions

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