Office 2007 Compatibility Issues – Uninitialized ActiveX controls will not be opened in this version of Excel

Posted on | September 1, 2010 | No Comments

I have been working with Office migration from version 2003 to 2007/2010. I faced quite a few problems in my earlier stages and it took lot of time to figure out the exact solution for some simple problems. So, thought it would be useful for someone who also involved in the migration.

Problem: Macro enabled Excel 2007 workbook with ActiveX control throws error ‘Uninitialized ActiveX controls will not be opened in this version of Excel’ while opening in Excel 2003 with read-only access.

Solution: There might be some ActiveX controls present in the workbook. The workaround is to replace all ‘ActiveX controls’ with ‘Form Controls’. This will resolve the issue.

Comments

Leave a Reply