- Apr 11, 2015
I have a pretty powerful Asus laptop running Excel 2013 and I'm working on a large file, 66 MB, with lots of formulas. I have calculation set to manual but when I attempt many simple tasks, like inserting a row, moving a row, adding a sheet etc, Excel stops responding. Sometimes if I wait a few minutes it accomplishes the task, other times it doesn't and I have to use Task Manager to End Task. I have been careful to not apply formatting to entire columns or rows, I use $ to restrict my formulas to the range they are being used but since I have calculation set to manual anyway, I'm don't see how formulas would be causing this anyway. Any thoughts?