Eliminate Formula Paste / Entry Calculation Delays
In my sheet with over 52000 cells containing simplistic formulas, I have noticed that copying and pasting just a few cells will exhibit an inordinate amount of delay (5 to 8 seconds) before the results are displayed. Interestingly, I can interrupt and shorten this delay by hitting the Enter key a second time (the first time I hit the enter key was to complete the paste).
So, in short, whatever happens when I strike the Enter Key twice after a paste should really happen after I strike the Enter Key one time. This will effectively eliminate the delay (and the blue spinning circle), allowing me to continue my editing work while the worksheet continues doing its calculations in background (I have automatic calculations turned on).
PS - Perhaps Excel is recalculating my entire workbook before coming around to the particular cells I just pasted in. Perhaps Excel could re-prioritize the calculation order so it first calculates the newly pasted cells before re-calculating the entire workbook.