Excel Functions from ADE

The Issue

Excel spreadsheet functions when invoked from an ADE Application through IIS seems to hang when ADE tries to bind to an instance of an Excel COM Object.

The Fix

Configuring the following settings on the machine seem to fix this issue.

1. Create a new standard user. E.g. 'ExcelRunner' with a password.
2. Set the Excel COM Objects to be invoked by this newly created user instead of the default Launching User.
   1. Launch DCOM Config: Start→Administrative Tools→Component Services→Computers→My Computer→DCOM Config.
      • Note: If you are running ADE 32-Bit on a Windows 64-Bit machine run the command Start > Run > 'mmc comexp.msc /32'
   2. Right click on 'Microsoft Excel Application' and then on 'Properties'.
   3. Click on the Identity tab.
   4. Choose "This user." as the account to run Excel Applications and type in the username and password of the new account.
   5. Click OK.
3. Give the new user permission to write files in the directory with the Excel file.