I have a MS word paragraph with number of individual cells linked to excel. When "update link", paragraphs are added before and after that cell. Checking the "Preserve formatting after update" option in Word does not seem to work.


I followed these instructions https://support.microsoft.com/kb/220526, by adding * CHARFORMAT \ to the link source code. It did not work, likely because the instructions are for Office 2000 and I have 2010.


Anyone have a solution to this?

Thanks