Cannot use object linking and embedding - EXCEL 2007 - DCOM

1: start->run and type 'DCOMCNFG'
2: Open 'DCOM Config' and locate 'Microsoft Excel Application'
3: Set its identity to 'The Launching User'.

Above settings fixed the problem.