Why is my sheet running so slow??

Originally Posted by newdoverman

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??

I have just started having the same problem. I have never had this problem for this week. I have been working on the same files for weeks and did not add any complex formulas.

When I start Excel, it is fine for about 15 minutes and then inserting or deleting row causing the file to slow down to a crawl. If I close and reopen, I it is fine again (for about 15 minutes).

The only thing that I might caused the issue is that the file went out and came back from someone using MAC. I resaved the file in my version of EXCEL.
It there such an issue regarding files going back and forth between WINDOWS and APPLE (MAC).

Thanks.

Jay

Originally Posted by newdoverman

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?