AELLC
Structural
- Mar 4, 2011
- 1,339
What I have is a fairly complex design workbook, about 3 MB in size in the Excel 2007 .xlsx format.
Depending on inputs, numerous cells return error values such as REF!, #N/A, or #VALUE!
However this is not a problem for the "bottom line" because the output cells are programmed to display various "warning" messages or blanks i.e. cell = " "
BTW the workbook contains no macros, VBA, UDF etc. I imagine it would work better with more efficient programming, but that is not an option as far as my capabilities.
Over the years, this workbook is growing increasingly complex - the problem is it has become slow to open and run on my current computer, which is not the latest but isn't ancient, either. I am reluctant to buy a new computer because of the usual unforeseen headaches. This machine has proven to be the most durable, reliable and it is fairly fast for other tasks.
My question - if I take the time to re-program to eliminate all error values, will the workbook process noticeably quicker?
Depending on inputs, numerous cells return error values such as REF!, #N/A, or #VALUE!
However this is not a problem for the "bottom line" because the output cells are programmed to display various "warning" messages or blanks i.e. cell = " "
BTW the workbook contains no macros, VBA, UDF etc. I imagine it would work better with more efficient programming, but that is not an option as far as my capabilities.
Over the years, this workbook is growing increasingly complex - the problem is it has become slow to open and run on my current computer, which is not the latest but isn't ancient, either. I am reluctant to buy a new computer because of the usual unforeseen headaches. This machine has proven to be the most durable, reliable and it is fairly fast for other tasks.
My question - if I take the time to re-program to eliminate all error values, will the workbook process noticeably quicker?