Error message when you save a macro-enabled spreadsheet in the "Excel 97 - 2003 Workbook" file format in Excel Starter 2010: "Uninitialized ActiveX controls cannot be transferred to the selected file format"

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

SYMPTOMS

You open a macro-enabled spreadsheet that contains an ActiveX control in Microsoft Excel Starter 2010. When you save the spreadsheet in the "Excel 97 - 2003 Workbook" file format, you receive the following error message:
Uninitialized ActiveX controls cannot be transferred to the selected file format. The controls will be lost if you continue.

CAUSE

Programmability is disabled in Microsoft Office Starter 2010. Therefore, ActiveX controls are not initialized during the file loading process. Because of this, the workbook cannot be saved in the legacy format.

WORKAROUND

To work around this issue, use one of the following methods:

Method 1 Use Excel Starter 2010 to save the file in the "Excel Macro-Enabled Workbook" file format to maintain the ActiveX controls.

Method 2 Use Microsoft Office Excel (non-Starter edition) to save the file in the "Excel 97 - 2003 Workbook" file format.

Properties

Article ID: 980222 - Last Review: September 12, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Office Starter 2010
Keywords: 
kbtshoot kbexpertisebeginner kbsurveynew kbprb KB980222

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