You could set calculation to xlManual so it only calculates when you
press F9 but the problem is probably due to volatile functions, check
out Charles Williams site and explanation, be sure to follow all his
suggestions! 'Faster Excel Calculations - Decision Models'
(http://www.decisionmodels.com/optspeedb.htm)

sreenet;529099 Wrote:
H1,
i am new in this form, i have a question. i am using excel 2003. in a
work
book am creating more sheets for the easy working. but now it take more
time
to open . how can i solve this problem.please advice me
thanks in advance
sree


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=145382