Monday, May 14, 2012

Error with BI Publisher: The macro cannot be found or has been disabled because of your macro security settings

I had issues with BI Publisher when using Word 2007 - specifically the following errors: "The macro cannot be found or has been disabled because of your macro security settings" and "Object library invalid or contains references to object definitions that could not be found"

Resolution:

The problem is cached EXD files.

1. Close Word,
2. Do a search on C drive *.EXD (include hidden files)
3. Rename them to .BAK
4. Go back into word and you should be able to Load Data

Hope this helps it worked for me

1 comment:

  1. Amazing Solution.

    Just renamed one file in forms folder from EXD to BAK and it worked.

    Thanks a lot

    ReplyDelete