Forum Discussion
Frustrated at Linking an Excel Cell to a word document
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.
Thanks for looking at this Doug. I really appreciate this. I'm going to make quite of few of these docs, each relating to their own metrics in a linked S/S. So it's important this works.
I tried what you said, and I ended up the same. I wasn't sure if the Bookmark was automatic, but if so I couldn't see it. I've attached a copy of the Word Doc, as this may further reveal something I'm missing.
Hope that helps!
toprobroy I do NOT see any of the following in that document:
- The value from Cell F27 of the Figures sheet of the Excel workbook
- Any links\linked fields
- Any bookmarks
- 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
