ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   please help!! (https://www.excelbanter.com/excel-programming/300419-please-help.html)

stevieh[_2_]

please help!!
 
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!

--
Message posted from http://www.ExcelForum.com


Masked Coder[_2_]

please help!!
 
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

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com