Values Cut Off in Table

If the values in a table appear missing or cut off in the linked table in DM Word, try these steps in order. After each step, update the table to check if the problem is resolved.

Set Formatting to Source

  1. In the DM Word report, right click the table, and select Manage CrossLinks
  2. Under the Formatting section, click on the word Destination, then from the drop down menu, select Source. If it already shows Source, close the window and skip to the next topic
  3. Right click the table and select Update CrossLinks

Turn Wrap Text Off

  1. In the Excel linking document, select all the values and dollar signs (not the labels or column headings)
  2. On the Home ribbon, click Wrap Text twice, to toggle it on and then off again, then Save
  3. In DM Word, update the table

Adjust Table Width in Excel

  1. Set zoom to 100% in both Microsoft Word and Excel
  2. Pick up the Excel applications window, and re-size it so that it is shorter on your screen than the Microsoft Word window. Compare the width of the table (all of the columns together) in Excel against the width of the table in Word
  3. Adjust column widths in Excel until the table's total width matches what is available in Word. For example, make the labels column smaller with wrapped text. Save
    • If you don't like any of the layouts in Excel that match table width in Word, try one of the following three recommendations, and then repeat this step
  1. In DM Word, update the table

Decrease Font Size

  1. In Excel, select the entire sheet. On the Home ribbon, set a smaller font size
  2. Double click the border between the row numbers to autofit the height of all the rows, then Save
  3. In DM Word, update the table

Adjust Left and Right Margins

Smaller left and right margins allow more room on the page for the table. For the best look, ensure that margins are consistent throughout the document and that they are still large enough to accommodate printing.

  1. In DM Word, check out the entire report
  2. On the Layout ribbon, click Margins > Custom Margins
  3. In the Margins window, adjust the left and right, or all margins, and at the bottom, select Apply To Whole Document

Set up Landscape Orientation

The landscape (horizontal) page orientation is often used for the Equity Statement or other very wide tables. This setting applies to an entire Word section, so first isolate the table with section breaks and adjust the report sections.

  1. Set up a Section Break (Next Page) before and after the table
  2. Remove and re-create the report section, so that the section breaks are not within a report section
  3. Click the table. On the Layout ribbon, select Orientation > Landscape

Check Excel Normal Style

  1. In Excel, on the Home ribbon, right click the Normal style and select Modify
  2. In the Style window, click Format
  3. On the Font tab, change font and size to match the font used in your report (typically Times New Roman or Arial, 10 pt)