I get the error "Unable to compile the document '<file location>' because it does not contain the Oracle Policy Modeling macros" everytime I compile an Excel document and Oracle Policy Modeling add-in is not present in Excel even when I open the file through project explorer. OPM shows the following error: "An error occurred while opening the document '<file location>': Unable to set the Installed property of the AddIn class". Please help me with this.
I found this in another link showing where to check that Oracle Policy Modeling Add-in is available.
For Office 2003 I found the add-Ins under Tools-Add-Ins
Take a look at the Installation Guide for Oracle Policy Modeling 10.3.1. There is a topic at the bottom that has some steps that might be relevant for your situation. For convenience I've copied some of the details:
The following is a possible workaround that will enable you to manually activate the Oracle Policy
Modeling AddIn for Excel:
1) Open the Excel document outside Oracle Policy Modeling.
2) Select Excel Options from the Office Menu (circle at top left). Select Add-Ins, then find
Manage: Excel Add-Ins, and click on Go...
3) Place a tick in the Oracle Policy Modeling Excel 2007 check box (if it is already ticked, try unticking,
clicking OK, and ticking it again).
4) Click on the OK button.
5) Try opening the workbook again in Oracle Policy Modeling.
If the Oracle Policy Modeling AddIn for Excel does not appear in step 3, you should be able to locate
it in the templates directory of the Oracle Policy Modeling installation. The default location is:
C:\Program Files\Oracle\Policy Modeling\templates\Oracle Policy Modeling Excel 2007.xlam