In Excel 2010
Go to File > Options.
Following screen will open
Select Trust center
Click on Trust center
settings
Select ActiveX
Settings and make sure setting match following screen
Then click on Macro
Settings and make sure settings match as following
Click on Protected
View and make sure setting match as following
Click on External
Contents and make sure setting match as following
Press Ok. Then again Press OK.
Now in Internet explorer
Go to Tools > Internet Options
Click on Security
Select Internet and
then on Custom Level
Scroll Down to
Download portion and match settings with following
Then Scroll down to miscellaneous
section and match setting with following
Then Scroll Down to
Scripting section and match setting with following
Press OK. Then again press OK.












