MacroEcon1337
Board Regular
- Joined
- Mar 16, 2017
- Messages
- 65
I was given a modest workbook (950 kb), and asked to optimize it.
Aside from a few loan amortization tables, there is not a lot of calculation going on. There are well under 5,000 rows total - across all 20-25 worksheets. But the calculation speed is VERY slow. You click "CALCULATE" in the bottom left, and that requires a full five seconds to complete... on a fast windows machine in Excel 2016.
I've worked with enough workbooks to know the "core mission / functions" of this workbook should NOT be taking as long as they do. There has got to be something foul in there slowing it down... somewhere.
I realize this is a vague question - but does anyone have any clever ideas for how to begin investigating a slow workbook, to home in on specific problems? I thought maybe deleting sheet-by-sheet, and observing when the performance speed picks up. But there are too many cross-dependencies.
Aside from a few loan amortization tables, there is not a lot of calculation going on. There are well under 5,000 rows total - across all 20-25 worksheets. But the calculation speed is VERY slow. You click "CALCULATE" in the bottom left, and that requires a full five seconds to complete... on a fast windows machine in Excel 2016.
I've worked with enough workbooks to know the "core mission / functions" of this workbook should NOT be taking as long as they do. There has got to be something foul in there slowing it down... somewhere.
I realize this is a vague question - but does anyone have any clever ideas for how to begin investigating a slow workbook, to home in on specific problems? I thought maybe deleting sheet-by-sheet, and observing when the performance speed picks up. But there are too many cross-dependencies.