View Single Post
  #1   Report Post  
Nathan
 
Posts: n/a
Default How come replace is so slow?

Every month I edit a worksheet with 22,000 rows.
I take 2 columns, hit find and replace, and change all blank cells to zeros.
In Excel XP it would take 3 seconds. Now it takes 3 minutes. This is
unacceptable, but I haven't found a fix or another reference to this problem.
Anyone know a way I get get Excel to do it's job?

Thanks,
Nathan