Excel 2010 – ActiveX controls resize or shift during or after print preview


Here's an interesting scenario. You have an Excel 2010 spreadsheet that contains multiple activeX controls. After you do a print preview of the spreadsheet and save the sheet, close it and re-open it you notice that some or all of the ActiveX controls are resized. They have either gotten smaller or larger, or have shifted left or right.

The fix for this problem is a two-part fix.

First, click on over to http://support.microsoft.com/kb/2596494 and click the hotfix link to request the hotfix package. Once you have the hotfix, install it.

After the hotfix is installed, you need to go into the registry and make an addition. From http://support.microsoft.com/kb/2596575:

1. 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\14.0\Excel\Options

3.On the Edit menu, point to New, and then click DWORD (32-bit) value.
4.Type MultiSheetLegacyPrint, and then press ENTER.
5. In the Details pane, right-click MultiSheetLegacyPrint, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7.Exit Registry Editor.

 

Comments (2)

  1. Wes says:

    This problem happens often with some of the models I use at work. Please push this fix out to all installations of Office 2010.

  2. SpreadSheetNinja(ssn) says:

    This happends to me in office 2010.

    It only happends on the activeX objects as far as i can see, it doesnt seem to be the size direct that gets changed, just crappier graphics or rendering (the smoothing is turned off or something) when the object is not in focuse. (aka clicked…)

    Iv tried pretty much everything, and the only sollution i came up to was to not use the activeX objects unless i realy needed to.

Skip to main content