Forum Discussion

toprobroy's avatar
toprobroy
Copper Contributor
Jul 19, 2023
Solved

Frustrated at Linking an Excel Cell to a word document

I'm trying to link a single cell from an excel spreadsheet into a Table in Word. Only two options to link and I want to keep the formatting in the Word doc, and just see the data from the Cell. It'...
  • Doug_Robbins_Word_MVP's avatar
    Doug_Robbins_Word_MVP
    Jul 20, 2023

    toprobroy It does IF you select the Paste link radio button before clicking on OK!

     

toprobroy's avatar
toprobroy
Copper Contributor
Jul 20, 2023
Sure but I'm not aware that I needed to make a Bookmark. Nor was I sure how to do it.
http://somup.com/c0iY6MzB2h You can see what's happening here if you take a quick look.
Thanks
Doug_Robbins_Word_MVP's avatar
Doug_Robbins_Word_MVP
MVP
Jul 20, 2023

toprobroy DON'T paste in HTML Format.  Paste as either Unformatted Text, or Unformatted Unicode Text.

 

Note, I only mentioned a bookmark because when I pasted in HTML Format, a bookmark was created that contained the cell reference.

  • toprobroy's avatar
    toprobroy
    Copper Contributor
    Jul 21, 2023

    Doug_Robbins_Word_MVP 

    Thanks Doug.

    To be honest I never thought the text part would link, even though it said it.

    Now it's working. I'm sorry about that. 😞

     

    I can begin to create the full links now and then duplicate for other communities.

    Really appreciated your help and engagement.

    Thanks

  • Doug_Robbins_Word_MVP's avatar
    Doug_Robbins_Word_MVP
    MVP
    Jul 20, 2023

    toprobroy It does IF you select the Paste link radio button before clicking on OK!

     

  • toprobroy's avatar
    toprobroy
    Copper Contributor
    Jul 20, 2023
    Ok. Thanks. Text doesn't give me a link though. I need to find the easiest way to duplicate my XLS for different communities and pull the data through to the Word Document. The formatting and linking are crucial to make light of this work. Pasting Text does work. I tried that first.