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

Issue:
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.

Cause:
This is a formatting issue caused by Microsoft® and not by Engagement or Workpaper Manager.  This problem has been occurring in past and current Microsoft® Office versions and has been reported to occur when opening workpapers inside and outside of Engagement or Workpaper Manager, or on machines that do not contain an installation of Engagement or Workpaper Manager present.

This issue has been reported and addressed by Microsoft® in the Microsoft® forum below:
Resolution:
We have collected knowledge from previous Microsoft® community articles and forums and below are the following suggestions we advise to perform:
  • Contact the system administrator and edit the registry by performing the following below:
  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).

      • Example Microsoft® Office 2016, Microsoft® Office 2019, or Microsoft® Office 365™ XX.X = 16.0
  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).
      • Example Microsoft® Office 2016, Microsoft® Office 2019, or Microsoft® Office 365™ XX.X = 16.0
  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 Microsoft® Excel® workbook, and the Microsoft® Word document and test to see if issue is resolved.
Alternative options if the above doesn't resolve the issue:
  1. Try and replicate the issue by sending the document outside of Engagement or Workpaper Manager.  If saving the document outside resolves, reimport the new document back into the binder.
OR
  1. If the behavior of the linked table is still the same, remove and recreate the linked table in the Microsoft® Word document.
OR
  1. If this behavior continues, and is only happening on one machine, or on a terminal server profile, reach out to the system administrator and recreate the Windows® profile for that machine/user.
OR
  1. Contact Microsoft® to troubleshoot the table and/or Microsoft® Office configuration.
  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!