I have a problem where I am trying to copy an excel cell that contains content using a formula, into a word document table cell and link them such that the formatting is used in word.
What happens is when I do a special paste, I am only allowed 2 linking options, Link & keep source formating, or Link & merge formatting. Both gives poor formatting results in which the content of the cell (a text returned from the formula through lookup) adds a line before the result, and a line after the result. This is unacceptable for my purposes as I am trying to minimize vertical white space, while locking the horizontal dimensions of the cell. Any attempt to remove those lines will delete the entire linked object. Pasting as text does not have this problem, as well as typing something into the word table cell, but I lose the automatic update/linking ability.
Making a new object for link gives an even worse result, where it is now pasting the entire spreadsheet into the single cell, and undoing all the formatting in the table.
Help would be appreciated, as this is very frustrating for something that should be very simple.
EDIT: I fixed part of my problem, it turns out I overlooked the Paste Link option in the Paste Special menu. I can now paste the unformatted text into the table cell and not have it add extra formatting from Excel, just like I want it (via Paste Link, and select Unformatted Unicode Text). However, this introduces a new problem where if the links are updated, if the new text of the table cell contains a space, only the first few words are in the correct format that I had specify for the table cell, while the extra words are using the default formatting, instead of the table cell formatting.
To replicate this, Create a table cell in word, assign any formatting other than your current default (such as changing font size to size 7, add bold and italics), then link a cell from excel via special paste by going paste options -> paste link -> unformatted unicode text. What you will see is that the link keeps default formatting and places it infront of the table cell formatting. If you highlight the entire cell again and change the formatting to what is wanted, the current version of the link is now in the proper format. However, if you update the link by changing the text in excel and it contains spaces (or basically more words), the first words will be in the correct formatting, while the last few words will be in the default formatting. The table cell will not be in consistent formatting after update. All done in Word and Excel 2013.