Thread: Worksheet Speed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Worksheet Speed

Hi Paul,

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

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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