Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Greeley, Colorado
    Posts
    188
    Thanks
    8
    Thanked 1 Time in 1 Post

    Show part of a word document in an excel cell(s)

    I have an area of a word doc that I'd like to display in Excel. Updating would only happen in word. The data could probably be put in a table and then display in multiple cells in Excel too. Any ideas? The only thing I can find is how to insert the entire document.

  2. #2
    Lounger
    Join Date
    Apr 2012
    Location
    Abergavenny, Wales, UK
    Posts
    25
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Hi

    If you set up a table in your Word Document, then copy that Table, got to Excel and choose Paste Special > Microsoft Word Object > and select Paste Link


    Regards
    Roger Govier
    Microsoft Excel MVP
    Attached Images Attached Images

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Greeley, Colorado
    Posts
    188
    Thanks
    8
    Thanked 1 Time in 1 Post
    Weird. I'd tried that before using the paste icon dropdown and special wasn't there, but with a right click in the cell it is!

  4. #4
    Lounger
    Join Date
    Apr 2012
    Location
    Abergavenny, Wales, UK
    Posts
    25
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Hi

    Yes that is the case when you are posting between applications.
    You will only see that option in the right click menu.
    I should have made that clear
    Regards
    Roger Govier
    Microsoft Excel MVP

Tags for this Thread

Posting Permissions

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