I have a fairly large file with multiple formulas. As I enter data or make modifications, there's is a frequent lagging that takes place. It's more aggravating than anything. I would like to create a macro that will report the timings of the formulas to determine which one is creating this issue. There were some codes published about 10 years ago but they did not work. The closest one was from Here which yielded nothing but 0's.
I have tried the most common suggestions, removing volatile formulas, Column references, etc... but I would rather learn what is causing this.
Does anyone have another way to determine which formula(s) are making my file lag?
Excel for Mac, V 16.54
I have tried the most common suggestions, removing volatile formulas, Column references, etc... but I would rather learn what is causing this.
Does anyone have another way to determine which formula(s) are making my file lag?
Excel for Mac, V 16.54