to speed up excel
 

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

to speed up excel
 

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

to speed up excel
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

Too many formulas for the size, too many rows/columns not needed. Probably
better to have ONE sheet and filter.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sreenet" wrote in message
...
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