![]() ![]() ![]() The INDIRECT function is single-threaded and so defeats Excel’s multi-threaded calculation engine: And of course this ripples down the dependency chains to make all dependent formulas also recalculate: SLOW!!! Its Single-threaded ![]() The INDIRECT function is volatile, which makes any formula that contains it volatile so that they defeat Excel’s smart recalc and recalc at every calculation. In no particular order here my reasons: you may have more! Its Volatile If you have a different choice you can cast your vote for your most evil function (and your favourite function) here. My choice for Excel’s most evil worksheet function is INDIRECT, for reasons outlined below. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |