ControlNotFoundException in Excel 2010

Error

Microsoft.VisualStudio.Tools.Applications.Runtime.ControlNotFoundException: This document might not function as expected because the following control is missing: Sheet8.

Solution

Finally figured it out. In excel, they have this option to enable 'Trust access to the VBA project object model'. It was disabled in the excel 2010 on the machines where it was not working.

Go to  File > Excel options (or Options) > Trust Center > Trust Center Settings > Macro Settings

There you should see 'Trust access to the VBA project object model' check box under 'Developer Macro Settings'. Check it and press ok.

Enabling this option got rid of the above error for us.