On the left hand side of the dialog box which came up when
dcomcnfg was run, navigate to ConsoleRoot->ComponentServices->Computers->MyComputer->DCOMConfig->MicrosoftExcelApplication, as below.
Right click on the Microsoft Excel Application, highlighted in red above. Select Properties.
In the dialog box that comes up, navigate to the Security Tab. Under the Access permissions section,
select the Edit button(highlighted in red below).
Add the
IUSR_MACHINE_NAME user to the list shown as described in
the method on the previous page, so that the box looks as below.