You could try turning the calculation of its in tools, options, an
calculations change it to manual.......best if you record this as
macro and put it in the auto open perhaps along wit
Application.EnableEvents=False......don't forget to turn them back o
at the end of the auto open or in the macro you require to run afte
that.
HTH
Simo
--
Message posted from
http://www.ExcelForum.com