excel vba--slow worksheet

[stevieh]

Hi all,

I have a timesheet that i have constructed that has vlookups, tw
pieces of vb coding and validation lists. It seems though to tak
forever when i try to insert a new column or try to copy cells. th
sheet is 1.5 mb.

Is there an easy way to speed the sheet up and also downsize the siz
of the sheet.

The other copy which is more or less the same is 225kb!

 

[q]

check the answer to the same question on ozgrid.com

 

[Dave Peterson]

If you turn calculation to manual, insert your rows/columns, then turn
calculation back to automatic, you might notice a better response.

You may want to take a look at these two sites
(Charles Williams and David McRitchie):

http://www.decisionmodels.com
http://www.mvps.org/dmcritchie/excel/slowresp.htm

Both these guys have notes about speed related issues.