When you rotate text in cells in an Excel 2007 document on a Terminal Services client that is running in Monitor Spanning mode, the text appears misaligned, partly or completely invisible, or the AutoFit Column Width function does not work

Article translations Article translations
Article ID: 972577 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You rotate text in cells in an Excel 2007 document on a Terminal Services client that is running in Monitor Spanning mode. For example, the screen resolution is 2560 x 1024 pixels. When you do this, the text appears misaligned, or partly or completely invisible. Additionally, the AutoFit Column Width function may not not work.

RESOLUTION

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
To fix this issue, apply the hotfix that is described in KB 971858, and then enable the hotfix. To do this, follow these steps:
  1. Apply the hotfix that is described in KB 971858. For more information about the hotfix, click the following article number to view the article in the Microsoft Knowledge Base:
    971858 Description of the Excel 2007 hotfix package (Excel.msp, Graph.msp, Xlconv.msp): June 30, 2009
  2. Enable the hotfix. To do this, follow these steps:
    1. In Windows Vista, Click Start
      Collapse this imageExpand this image
      the Start button
      , type regedit in the Start Search box, and then press ENTER.

      Collapse this imageExpand this image
      User Account Control permission
      If you are prompted for an administrator password or for confirmation, type the password, or provide confirmation.

      In Windows XP, click Start, click Run, type regedit in the Open box, and then click OK.
    2. Locate and then click the following registry subkey:
      HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options\
    3. On the Edit menu, point to New, and then click DWORD Value.
    4. Type RDPCheckAspectLog, and then press ENTER.
    5. Right-click RDPCheckAspectLog, and then click Modify.
    6. In the Value data box, type 1, and then click OK.
    7. Exit Registry Editor.

Properties

Article ID: 972577 - Last Review: July 1, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Office Excel 2007
Keywords: 
kbqfe kbexpertiseinter kbsurveynew kbprb KB972577

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com