Quote Originally Posted by newdoverman View Post
I removed all conditional formatting (there was a huge amount of overlapping formatting) by copying the rows and pasting special first the values then paste special formulae while the selection was maintained.

As noted, the Rank formula is very strange in that the whole range isn't selected for the ranking.

The workbook at least reacts in a normal fashion time-wise.

Hi,

I have this same problem. I tried to remove conditional formating, but it doesn't get any better. It seams, that problem groving with every new row in sheet "Zurn". Could anyone help me to solve this problem?
I tried to attach the file, but didn't find how to do that??