Oct 26 2020 03:15 AM
Maybe it is just that you don't like change. I assure you that the new paradigm is far better than the garbage that was traditional spreadsheet development!
Perhaps you would like to present an example in which the dynamic range functionality has returned an incorrect result, in which case the community could advise on how it may be corrected. Other than that, it is a case of sticking with increasingly obsolete versions of Excel and the development practices that they required.