There are (2) error log sources that the office uses when errors occur. Microsoft Office Diagnostics and Microsoft Office Sessions. You can try to use them for troubleshooting.
Office 2010 You can enable the interface error dialogs by going to the menu "File-> Options-> Advanced->" Developers "and checking" Show add-in user interface errors ".
Office 2007 You can enable the interface error dialogs by going to Tools-> Options-> Other-> General-> Advanced Settings and checking "Show user interface errors". There is also the option to enable logging (uncertainty about its behavior)
source share