Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA or formulas?
I have a rather large workbook that has between 112,000 and 113,000 formulas
in it on 80 odd worksheets, and quite a bit of VBA running in the background. The workbook is running around 9.5 MB and on my work laptop it's starting to get unstable (cheap skates here won't spring for more RAM or a computer with a better processor). The workbook will sometimes crash, meaning I get a message that the file is corrupted and it's unrecoverable, if I have anything open other than Outlook, so I'm assuming I need to reduce the size of the workbook. I can get 95% of everything that needs to be done by using formulas, or can drastically reduce the number of formulas by using VBA. I'll still need some since my boss wants some of them there so he can follow where the numbers came from. My question is which is more efficient? If it matters I'm using Excel 2003, and 65 of the worksheets are identical formula-wise. Thank you in advance for your help. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200911/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
convert all formulas on a worksheet to aray formulas | Excel Programming | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
AdvancedFilter on cells with formulas, returning values and not formulas | Excel Programming |