Worksheet Speed

[PaulW]

I have a spreadsheet with 5 pages, 2 are external reports, 2 are "calc"
pages, and one is a "Final" page. Also wrote into the workbook is an 8 page
Userform filled with a good hundred textbox's, combobox's, labels, and
buttons. As i've developed this workbook it gets slower and slower do to
additional formulas, and such.

Now it's finished and I need to speed it up. Only 2 processes are really
slow out of the entire thing, and running one after the other takes in excess
of 10 minutes.

Basically, I need to speed these things up. but with the vast amount of
code, and formulas, can I easy run a macro or something, and find out which
cells/lines of code are taking up processing power/time/etc...

 

[Niek Otten]

Hi Paul,

For lots of tips about Excel performance, visit Charles Williams' site:

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a spreadsheet with 5 pages, 2 are external reports, 2 are "calc"
| pages, and one is a "Final" page. Also wrote into the workbook is an 8 page
| Userform filled with a good hundred textbox's, combobox's, labels, and
| buttons. As i've developed this workbook it gets slower and slower do to
| additional formulas, and such.
|
| Now it's finished and I need to speed it up. Only 2 processes are really
| slow out of the entire thing, and running one after the other takes in excess
| of 10 minutes.
|
| Basically, I need to speed these things up. but with the vast amount of
| code, and formulas, can I easy run a macro or something, and find out which
| cells/lines of code are taking up processing power/time/etc...

 

[Snake Plissken]

maybe you should turn autocalculation off? ( and turn it on only in certain
conditions )

 

[a7zulu]

you could probably trying creating an Excel add-in, which is creating
a .xll file