Excel runs slow

[Walter]

We run Excel 2002 here at work, and I have used quite a bit of VBA coding and
users buttons and forms to make one particular workbook work. Almost each
day a new workshhet gets added to the workbook, and Excel just seems to run
slowewr and slower each day. Right now we have 50 worksheets in this
particular workbook.

Can somebody explain to me how to speed our Excel version up?

 

[Simon Lloyd]

Take a look at Charles Williams (MVP) site, here 'Volatile Excel
Functions -Decision Models'
(http://www.decisionmodels.com/calcsecretsi.htm) read the section on
volatile functions, Charles has gone to great lengths to help you reduce
workbook bloat and speed things up


We run Excel 2002 here at work, and I have used quite a bit of VBA
coding and
users buttons and forms to make one particular workbook work. Almost
each
day a new workshhet gets added to the workbook, and Excel just seems to
run
slowewr and slower each day. Right now we have 50 worksheets in this
particular workbook.

Can somebody explain to me how to speed our Excel version up?


--
Simon Lloyd

Regards,
Simon Lloyd
'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)

 

[rumkus]

If you are using quite a bit of VBA code I'd say clean your workbook
time to time.
Export your codes to txt files, save your workbook with no code on it
and transfer them again.
Below address will help you. Rgds

http://www.cpearson.com/excel/vbe.aspx