Thursday, 20 February 2014

Wednesday, 12 February 2014

When BI Publisher desent works in Office 2010


Finally figured out what is the root cause of this issue is. This is caused by one of the Microsoft's windows security update that installs VBA runtime file, which is supposed to fix a VBA vulnerability but caused third party softwares (plug-in) stop working! Yes, this third party software in this case is the Template Builder. 

Here is the detail of the MSFT update patch.

http://support.microsoft.com/default.aspx?scid=kb;en-us;932349

Basically what we need to do is to delete '.exd' files, which have been invalidated by the update, then refresh them by restarting the Word again. In my case, I found one file under C:\Documents and Settings\Administrator\Application Data\Microsoft\Forms so deleted it, then restarted Word, now it's all working.