I'm working on a huuuge excel file that keeps freezing and is therefore taking me ages to finish working with. I'm hoping someone can advise how to lower the processing time. This file has 100K rows. It even freezes when I'm scrolling! The main actions I'm taking within it, if this is relevant, is that I'm applying a couple filters at a time then putting in information into the first line and pasting that all the way down.
I was working on another file of the same length last week. That was also very slow in the beginning until I shut off automatic calculations, made them manual. But that hasnt fixed things here.
Can anyone help?