Before working on any Web ADI document the user needs to
perform certain prerequisite settings in internet explorer and excel –
Internet Explorer Settings
When the
Security page appears, click the "Internet" icon in the "Select
a zone" box and then click the "Custom Level.. " button. (The custom level button will be active only if user has admin access for his system)
Once the
"Security Settings" dialog box appears, scroll down to
"Scripting" on the menu. Enable "Allow status bar updates via
script" Select OK. You may
receive a Warning. Please select "Yes"
Uncheck the option – Enable Protected mode
Close the
browser window so that new settings can be used
Microsoft Excel Settings
Navigate to Excel Options à Trust Center à Trust Center Settings à Macro Settings
Select ‘Enable all macros’ option and ‘Trust access to the VBA project object model’ options
Once the above steps are completed, the user will be able to open web ADI sheet
No comments:
Post a Comment