Excel links not maintaining format when updated in Word 2013

I have a problem where I have a table created in word, and certain cells in the table contain links to an excel spreadsheet that contains text in the cell (like a text description). I copy the cell I wish to obtain the information from, and do a special paste into a table cell with paste link -> unformatted unicode text. I then format the entire cell into the font and fontsize and bold/italics as needed. However, whenever the link is updated due to new content in Excel, the resulting table cell in Word does not maintain the formatting for the entire cell, instead having parts of it in the correct format, and other parts in the default format of the word document. 

I have messed around with settings and searched the internet for a week now to no avail (apparantly nobody ever saw this as an issue), but for my purposes where I would like to have as little human intervention as possible, I want to be able to not have to go into the document and fix every cell so the contents in individual cells are correctly formatted. It should be noted that the formatting between cells will be inconsistent due to the nature of the work, but the content inside a single table cell should be consistent, but an updated excel link changes the formatting if the new text contains a space that was not in the previous link. 

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 with random text in 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.

Help would be appreciated as this is driving me crazy.
Answer
Answer

Press ALT+F9 to toggle on the display of the field codes in the Word document and then add a

\* charformat

switch inside the closing } field delimiter.  Then apply the desired formatting to the L of LINK.

Use ALT+F9 again to toggle off the display of the field codes.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
It's time to replace ‘Diversity, Equity & Inclusion’ with ‘Excellence, Opportunity & Civility’ - V Ramaswamy

4 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated December 19, 2023 Views 3,381 Applies to: