Perform the below steps for the E-Business Suite WebADI component to function properly in Excel 2007 & 2010.
Excel 2010:
Click File -> Options
Click 'Trust Center' link in the 'Excel Options' window.
Click 'Trust Center Settings...' button.
In the 'Trust Center' window click 'Macro Settings' link from the menu on the left.
Under 'Macro Settings' check 'Disable all macros with notification'.
Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
Click 'OK' button to close the 'Trust Center' window.
Click 'OK' button to return to the spreadsheet.
Excel 2007:
Click the Office Button (top-left button in the window)
Click the 'Excel Options' button.
Click 'Trust Center' link from the menu on the left.
Click 'Trust Center Settings...' button.
In the 'Trust Center' window click 'Macro Settings' link from the menu on the left.
Under 'Macro Settings' check 'Disable all macros with notification'.
Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
Click 'OK' button to close the 'Trust Center' window.
Click 'OK' button to return to the spreadsheet.
Reference: Metalink note 1077728.1
