The entry for "Microsoft Excel Application" is not there in DCOM Config (tried in both 32-bit and 64-bit). How can I make it shows up there? I have Microsoft Office installed.
If you cannot find 'Microsoft Excel Application' in either 32-bit or 64-bit DCOMCNFG, you might go into registry to HKEY_CLASSES_ROOT/AppID and find the CLSID for your version of Excel (Excel 2013 has an AppID of {00020812-0000-0000-C000-000000000046})
Check that the (Default) REG_SZ for this key has a value set for it.
If not, change the default value to "Microsoft Excel Application" and after relaunching DCOMCNFG you should see "Microsoft Excel Application" in the DCOM tree.