please help!!

S

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!
 
M

Masked Coder

In my experience, the more formulas you have on the sheet(s), the bigge
the file size and the longer it takes to do things.
If you are comfortable with code you could write macros to accomplis
the same things and have them triggered by events
 
Top