Hi Ani,

hi there is no problem in disk i/o

I know.

the excel contain a good number of sheets
some containing macro

Does any of the VBA project(s) contain userforms?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com