Form control is displayed in the wrong position when you print a workbook in Excel 2010

View products that this article applies to.

Symptoms

Assume that you add a form control to a workbook in Microsoft Excel 2010, and then you select the Automatic Size check box for the form control. When you print the workbook, the form control is displayed in the wrong position in the printout and on the computer.

Note Every time that you move the form control back to the original position and then print the workbook, the form control is displayed in a different position in the printout and on the computer.

↑ Back to the top

Resolution

To resolve this issue, apply the following update:

2687347 Description of the Excel 2010 hotfix package (Excel-x-none.msp): August 28, 2012

Registry key information

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

After you install the hotfix package, follow these steps to enable the hotfix:

Click Start, click Run, type regedit in the Open box, and then click OK.
Locate and then select the following registry subkey:
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
On the Edit menu, point to New, and then click DWORD (32-bit) Value.
Type MultiSheetPrint, and then press Enter.
In the Details pane, right-click MultiSheetPrint, and then click Modify.
In the Value data box, type 1, and then click OK.
On the Edit menu, point to New, and then click DWORD (32-bit) Value.
Type LegacyAnchorResize, and then press Enter.
In the Details pane, right-click LegacyAnchorResize, and then click Modify.
In the Value data box, type 1, and then click OK.
Exit Registry Editor.