I have a large Excel file, about 150MB, with many formulas. In excel 2007, we were able to insert and delete rows fine. In our current Excel, v2016, inserting or deleting rows takes anywhere from 30 seconds to a few minutes. Is there any way we can solve this? The delay in inserting/deleting rows makes many macros unusable.
Solved by M. C. in 25 mins