WARNING: This is mere guideline, we do not enforce it and it should be at your own discretion to apply/follow it.

Error Message:

 Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.office.Interop.excel.application'.

Symptoms:

Error appears during AM generation.

Resolution:

For a computer running MS Office 2013

1. Please open regedit.exe, (vai start button/menu or windows search box)
2. Navigate to HKEY_CLASSES_ROOT-->TypeLib-->{00020813-0000-0000-C000-000000000046}
3. Delete:- HKEY_CLASSES_ROOT-->TypeLib-->{00020813-0000-0000-C000-000000000046} --> 1.9
4. Navigate to HKEY_CLASSES_ROOT-->TypeLib-->{00062FFF-0000-0000-C000-000000000046}
5. Delete:- HKEY_CLASSES_ROOT-->TypeLib-->{00062FFF-0000-0000-C000-000000000046} --> 9.6
6. Close regedit

And for a computer running MS Office 2010 you should only have the following entries

HKEY_CLASSES_ROOT-->TypeLib-->{00020813-0000-0000-C000-000000000046} --> 1.7

HKEY_CLASSES_ROOT-->TypeLib-->{00062FFF-0000-0000-C000-000000000046} --> 9.4