We are using Analysis Excel tool, which contains lot of Formatting,
Macros,User defined functions etc.,.This Excel tool is developed in Excel
2003 and it gets the data from the access database. As most of the users of
this tool are using Excel 2007, when ever they open and Click on the "Update"
button which gets the data form the Access database, as soon as they select
any data in the drop down list...Excel is getting hanged and worksheets are
getting mixed with other sheets.
When i scroll up and down...then it is working fine..

Please suggest some permanent solution for this..let me know if you need any
further information.