Note:

Once Excel has been setup in DCOMCNFG to run as a Service on the Server one should no longer try and use Excel as a Client tool.  If you do, an error message Cannot use object linking and embedding will appear and the Sharperlight add-in will be dropped. This error message appears because Excel has been setup to run as a Service to Publish Excel through the Web Channel and is no longer suitable as a Client tool.   If you try and use Excel as a Client after it’s been setup as a Service, it will drop the add-in and Published reports will show Sharperlight formulas as #NAME and will no longer extract data from Sharperlight.  If this does happen try and rereference the Sharperlight add-in and close Excel.

First try this in the Windows Start Menu if your using Windows 64bit

MMC comexp.msc /32

Otherwise try these steps

​

Missing Excel​ Entry​

1. In DCOMCNFG, right click on the My Computer and select properties.
2. Choose the COM Securities tab
3. In Access Permissions, click “Edit Defaults” and add Network Service to it and git it “Allow local access” permission. Do the same for <Machine_name>/Users.
4. In launch and Activation Permissions, click “Edit Defaults” and add Network Service to it and give it “Local launch” and “Local Activation” permission. Do the same for <Machine_name>/Users

http://social.technet.microsoft.com/Forums/windows/en-US/dde69147-a01a-4eb1-8ea9-31adbf874bed/microsoft-excel-application-entry-missing-in-dcomcnfg

On 64 bit system with 32 bit Office try this:

1. Start
2. Run
3. mmc -32
4. File
5. Add Remove Snap-in
6. Component Services
7. Add
8. OK
9. Console Root
10. Component Services
11. Computers
12. My Computer
13. DCOM Config
14. Microsoft Excel Application