Search This Blog

Tuesday, April 19, 2011

The macro cannot be found or has been disabled (BI Publisher and Office 2010)

Recently I have upgraded MS Office from 2007 to 2010. As I work on some BI projects, part of mine set of oracle programs is oracle BI Publisher Desktop, which use Word as report template designer. When I run BI Publisher macros in Word 2010 I got following error:
The macro cannot be found or has been disabled because of your macro security settings

The solution

The solution shown here really works (tested on several computers), so I'm writing this down to be more like documentation for future reference to anyone stack on this case. Idea is to remove old *.EXD files from any location in %USERPROFILE% folders that might exists.
Because mine praxis is to have separate %USERPROFILE% folder location then where are OS files (different then partition then C:), exd file was found as shown. In mine case it was only in one folder:

D:\Users\Sandip\Application Data\Microsoft\Forms>dir

 Volume in drive D is Data
 Volume Serial Number is 505E-794F
  
 Directory of D:\Users\Sandip\Application Data\Microsoft\Forms
  
01.02.2011  11:45    <DIR>          .
01.02.2011  11:45    <DIR>          ..
12.03.2009  15:17           165.808 MSComctlLib.exd
31.08.2010  10:34            11.776 WINPROJ.box
01.02.2011  11:19             7.168 WINWORD.box
               3 File(s)        184.752 bytes
               2 Dir(s)  51.699.859.456 bytes free
  
D:\Users\Sandip\Application Data\Microsoft\Forms>
So all you have to do is:
  1. Rename existing "MSComctlLib.exd" file to "MSComctlLib.exd_bak"
  2. Install BI Publisher again.
It should work....

Cherrrrrrrssssssssss...

Reference :- http://damir-vadas.blogspot.com/2011/02/macro-cannot-be-found-or-has-been.html?showComment=1303225868321#c4865170160256515104

4 comments:

  1. This solution is different from the others because they don't tell you to install BI Publisher desktop again. That step made the difference for me.

    ReplyDelete
  2. Thanks a lot for the solution... it fixed the issue as you said...

    ReplyDelete
  3. Thank You for ur comments Jim and Kamlakar!!!

    ReplyDelete
  4. It doesn' work for me I am still getting the same message
    The macro cannot be found or has been disabled becaus of you Macro security setting

    ReplyDelete