Forum Discussion
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's putting other things in there like so:
Here's the codes but I can't individually remove them. Everything gets removed?
Anyone got a clue on this. I'm going to set links up for quite a few cells from a Multi Tab Worksheet in Excel but if I can't get one, there's no point in sorting them all out now.
I even tried a Named Cell, but couldn't get that to work?
What is the problem?
Help Please
toprobroy Can you upload a copy of the workbook and the document so that we can investigate what is causing the issue.
Sure the Cell I want to first get working is in workbook- Figures - Cell f27
Did you need the Word Document as well?
[ADMIN] - We removed the XLS File due to potential privacy issues
toprobroy Using Paste>Special>Paste link as HTML format,
In addition to the data, a bookmark is inserted in a separate paragraph before the data and another empty paragraph is inserted after it
However, if it is pasted as either Unformatted Text, or Unformatted Unicode Text, just the data is pasted as shown in the second instance of the data in the above screenshot.
