The font style of text in a linked Microsoft® Excel® worksheet object may change in Microsoft® Word.

Microsoft® Excel® data inserted into a Microsoft® Word file using Object Linking and Embedding (OLE) may change size or shape when the Microsoft® Word file is opened at a later time.

This issue has been addressed by Microsoft® in the Microsoft® forum Linked Excel Objects in Word font and spacing become distorted when saved.

Steps to take:
  1. Close out of all Office documents.
  2. Click the Windows Start button, and then type regedit and press enter.
  3. Locate and then select the following registry subkey:
    • HKEY_CURRENT_USER\Software\Microsoft\Office\XX.X\Common (where XX.X is referencing the version of Office on the machine).

  4. On the Edit menu, point to New, and then click DWORD Value.
  5. Type UsePrinterDCForMetafile, and then press ENTER.
  6. Right-click UsePrinterDCForMetafile, and then click Modify.
  7. In the Value data box, type 1, and then click OK.
  8. Locate and then select the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Office\XX.X\Excel\Options (where XX.X is referencing the version of Office on the machine).
  9. On the Edit menu, point to New, and then click DWORD Value.
  10. Type QFE_Boston, and then press ENTER.
  11. Right-click QFE_Boston, and then click Modify.
  12. In the Value data box, type 1, and then click OK.
  13. On the File menu, click Exit to exit Registry Editor
  14. Open the Excel and Word document
    • If the behavior of the linked table is still the same, recreate the linked table in the Word document.
If this behavior continues, and is only happening on one machine, then recreate the Windows® profile for the machine. 

 
  Solution Tools
  Attachments
 Solution Id 000074861/000074861
 Direct Link
To provide feedback on this solution, please login.

Your feedback about this article will help us make it better. Thank you!